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


[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

Original text of this message