Re: Default sequence number
From: Imtiaz Ahmed <imtiaz_at_qatar.net.qa>
Date: 1996/10/26
Message-ID: <01bbc329$460f3da0$1c2185c2_at_r2d2>#1/1
Date: 1996/10/26
Message-ID: <01bbc329$460f3da0$1c2185c2_at_r2d2>#1/1
[Quoted] Create the Required sequence for th ID and then Create a database trigger xxx before insert on <table> for each row to select the value from the created sequence. This way yo'll not have to include the ID value when you submit an insert through SQLPLUS
Hope this will help you
Imtiaz Ahmed.
Imitaz_at_qatar.net.qa Received on Sat Oct 26 1996 - 00:00:00 CEST