Re: Oracle column default value

Hello, was,

near 06:42 14-Jul from was79_at_wanadoo.fr:

> Hi All,
>
> I 'm using Oracle 8i and i have a table table1 with two columns:
>
> COL1 not null
> COL2 DEFAULT 'N'
>
> if i make an insert :
> insert into table1(COL1,COL2) values (1,null)

insert into table1(COL1,COL2) values (1,nvl(null,'N'))

> The column COL2 is null and I would like to have N (the default value)
>
> when i make an insert like this:
> insert into table1(COL1) values (1)
> it's work well. The value of the COL2 is 'N'.
>
> i don't want to use the trigger to do this.
>
> Thanks for your help.

-- 
wbr,
Wit.