Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> About default value in create table

About default value in create table

From: Michael <michaelwah_at_tom.com.hk>
Date: 7 Jul 2004 08:29:59 -0700
Message-ID: <57aa0935.0407070729.36b93e7e@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US