Peter thanks.
I forgot that null insert is not converted to the default.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 11:03 PM
Hello Andrey
The correct answer depends on what you want !
if you can
|
|| |
|+-
|
|
|
| To: [EMAIL PROTECTED]
|
| cc: (bcc: Rachel Carmichael)
|
| Subject: A trigger vs. default value
in|
| a table
Thanks a lot to all who replied !
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Mon, May 13, 2002 11:03 PM
To: Multiple recipients of list ORACLE-L
Hello Andrey
The correct answer depends on what you want !
if you can live with null
Hello Andrey
KISS - Why write code to do what oracle does for you?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 6:23 PM
Dear list !
I need a very simple thing : each time a certain field is null
|
|| |
|+-
|
||
| To: [EMAIL PROTECTED] |
| cc: (bcc: Rachel Carmichael) |
| Subject: A trigger vs. default value in|
| a table |
|
Dear list !
I need a very simple
Hello Andrey
KISS - Why write code to do what oracle does for you?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 6:23 PM
Dear list !
I need a very simple thing : each time a certain field is null
Hello Andrey
The correct answer depends on what you want !
if you can live with null values in the column then
a default for the column is OK, but if you want to
handle a insert with a null then you need a trigger.
Se the little example :
SQL create table t (a number, b number default 10);