Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question ...
Kamran Remin wrote:
> 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
>
>
In my 8i scripts, I write it:
foo number(2) default 0 not null Received on Thu Jan 23 2003 - 11:53:13 CST