Re: Default sequence number
From: Alf-Kenneth Aabel <alf-ka_at_online.no>
Date: 1996/10/28
Message-ID: <551sgn$5b_at_o.online.no>#1/1
Date: 1996/10/28
Message-ID: <551sgn$5b_at_o.online.no>#1/1
[Quoted] nardone_at_patriot.net (Joe Nardone) wrote:
>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
[Quoted] No, this is not true at least not in Oracle 7.2 and higher. Oracle will run the trigger before checking the constraints, so a trigger is the right way to implent the IDENTITY column which exists in Sybase.
Name: Alf-Kenneth Aabel Title: Senior Software Engineer Company name: PRIDE AS Address: Wdm. Thranesgt. 77 0175 OSLO Ph work: +47 22 20 21 50 Fax: +47 22 20 70 39 Ph private: +47 22 35 64 17 Pager: +47 967 16998 Email: alf-ka_at_online.no _____________________________________________________________Received on Mon Oct 28 1996 - 00:00:00 CET