Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: using nvl when insert or update
In article <3c8dd54b$0$8514$ed9e5944_at_reading.news.pipex.net>, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:
>or even better alter table mytable modify (mycolumn not null default 0);
>this gives the optimiser more info about the data in the field, this is of
>particular relevance when choosing index access path.
In 8i, at least, the "default 0" must come before the "not null." I get an error ("missing right parenthesis") otherwise. Received on Tue Mar 12 2002 - 07:23:42 CST