Re: SQLBase and Oracle differences

Hi Jukka,

        What does a NOT NULL WITH DEFAULT do or mean?

        I am not sure but I think that the following will do what you want:

        <column_name> VARCHAR2(10) DEFAULT 'value' NOT NULL,

regards

Jerry

Jukka Peltonen 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 .....

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group