Re: Oracle9i - Default values

On Tue, 28 Sep 2004 17:08:34 +0200, Latyr_Dev <Latyr_dev-remove.this-_at_hotmail.com> 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

Cannot confirm your observation. Please post the exact INSERT statement(s).

• Kenneth Koenraadt