Oracle9i - Default values

Hi

I have noticed something somehow strange. The following SQL has been run against an Oracle8i & Oracle9i database CREATE TABLE Team (

	Portfolio_ID NUMBER ( 10 ) NOT NULL,
	Project_ID NUMBER ( 10 ) NOT NULL,
	Member_ID NUMBER ( 10 ) NOT NULL,
	Role VARCHAR2 ( 3 ) NOT NULL,
	R_ART NUMBER ( 1 ) DEFAULT 0,
	R_GED NUMBER ( 1 ) DEFAULT 0,
	R_LVS NUMBER ( 1 ) DEFAULT 0
	)

With Oracle8i, if no value is given during insert R_ART=R_GED=R_LVS=0 But with Oracle9i, I don't have any value in R_ART; R_GED; R_LVS

Why ???

Did I miss something ?

Thanks in advance Received on Tue Sep 28 2004 - 10:08:34 CDT