Re: SQLBase and Oracle differences

I think You are trying this way

create table aaa
( aa date not null default sysdate,
  name varchar2(10));

and Hence getting the message ORA-00907 Missing Right Parenthesis

You can do the above in the following way to solve your problem

create table aaa
( aa date default sysdate not null,
  name varchar2(10));

If still nay problem , send me the email

Thanks
Indy Johal

In article <6re5gd$2c4$1_at_news1.global-one.fi>,   "Jukka Peltonen" <jukka.peltonen_at_komartek.fi> wrote:
> Hello!
>
> I am porting my SQLWindows app from SQLBase 6.X database
> to Oracle 7.3.
>
> When I try to create a column with option NOT NULL WITH DEFAULT
> Oracle says missing right parenthesis
>
> I have looked oracle documentations but I haven't found any mention
> about "not null with default" option.
>
> Is there such a option ??
>
> I can solve this problem by changing my app, but .....
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 21 1998 - 08:19:51 CDT