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)