Write it as DEFAULT 0 NOT NULL and all will be fine. NOT NULL is
constraint and should be AFTER the default value, not before.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Kamran Remin" <toxic.waste.inc_at_gmx.net> wrote in message news:3e301b1b_1_at_news.arcor-ip.de...
> Hi NG,
>
> i want to create a table, but there seems to be a problem. when i write "foo
> number(2) not null default 0" oracle says:"ORA-00907: missing right
> parenthesis" if i write "foo number(2) not null default '0' " oracle
> says:"ORA-00907: missing right parenthesis"
>
> So what is the right way to write a line which contains "defalut 0" /
> "default '0' "?
>
> Regards,
> Kamran Remin
>
>
Received on Thu Jan 23 2003 - 11:03:31 CST
