| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> About default value in create table
I am a new user of Oracle. I got a problem about create table.
I create a table
create table TEST (
COL1 nchar(10) default '' not null,
COL2 nchar(10) default '' not null
); /* this line is OK */
insert into TEST( COL1 ) values ( 'A' )
/* this line fail, becuase cannot assign NULL to COL2 */
What is wrong.... ??? Received on Wed Jul 07 2004 - 10:29:59 CDT
![]() |
![]() |