Default values

Hi all !

 I'm a newbie at Oracle but have experience in CA-Ingres and MS-SQLServer.  I've created a database in Oracle, not allowing NULL values in any column and with default values.

 Now I got two problems.

1. I like varchar columns to have a default value separated from NULL but not one blank. In both CA-Ingres and MS-SQLServer am I able to define '' as the default value. How do I do this in Oracle 8 ?
2. I'm not able to do a insert, without specifing values to all columns. I got error message "null values not allowed" doing this, despite I have declared default values for the columns not involved in the insert. I like the default values to get inserted when the column is not mentioned in the insert. How do I do this ?? (the second problem might be just depending on problem 1)

TIA
 Sten Selin, s.selin_at_viska.se
 Viskan Info System, Sweden
 www.viskan.se

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 18 1999 - 01:42:43 CST