From: wit_no@spam_dba.kiev.ua   
      
   Hello, was,   
      
   near 06:42 14-Jul from was79@wanadoo.fr:   
      
   > Hi All,   
   >   
   > I 'm using Oracle 8i and i have a table table1 with two columns:   
   >   
   > COL1 not null   
   > COL2 DEFAULT 'N'   
   >   
   > if i make an insert :   
   > insert into table1(COL1,COL2) values (1,null)   
      
   insert into table1(COL1,COL2) values (1,nvl(null,'N'))   
      
   > The column COL2 is null and I would like to have N (the default value)   
   >   
   > when i make an insert like this:   
   > insert into table1(COL1) values (1)   
   > it's work well. The value of the COL2 is 'N'.   
   >   
   > i don't want to use the trigger to do this.   
   >   
   > Thanks for your help.   
      
   --   
   wbr,   
   Wit.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)