Re: Default sequence number

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