Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle9i - Default values
Latyr_Dev wrote:
> 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
What is missing is enough information for us to try to duplicate the problem.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Wed Sep 29 2004 - 23:58:08 CDT