Re: Default sequence number

Imtiaz Ahmed (imtiaz_at_qatar.net.qa) wrote:
: 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
:

Unfortunately (this is from memory; please check it out) you won't be able to declare your column NOT NULL. Apparently, Oracle checks NOT NULL constraints before doing the 'before-insert' and 'before-update' triggers.

Joe

-- 
                                   
=-------------------------------------------------------------------------=
Joe Nardone <nardone_at_patriot.net>
  "There are many dying children out there whose last wish is to meet me."
                                                  -David Hasselhoff