Re: Oracle9i - Default values

In article <4159ac3b.2387968_at_news.inet.tele.dk>, Kenneth Koenraadt says...
> 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
>

Hi,

It is working fine. The bad behavior was due to the use of OEM graphical tool to perform the insert test. If I use an SQL insert everything is ok.

Thanks Received on Mon Oct 11 2004 - 07:15:59 CDT