Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLBase and Oracle differences
Thank You Jerry!
That was what needed!
In SQLBase WITH DEFAULT SQLBase set value automatically to ' ', 0 or current date if there is no value in insert clause
regards Jukka
Jerry Gitomer wrote in message <35DAC0B8.2037_at_ictgroup.com>...
>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
>
>
Received on Thu Aug 20 1998 - 01:02:21 CDT
![]() |
![]() |