Triggers and default values problem

Hi,

I have a table where MyField is a varchar2 with a default value = 'DEFAULT VALUE' :
MyTable(..., MyField, ...)

I have a trigger on MyTable on Before Insert : MyTrigger

In my trigger i want to test if MyField is NULL when users insert rows in MyTable. But when i read :NEW.MyField, the field is never NULL because i give it a default value !!!
I 'd like to give a default value to MyField and to know when it's NULL on before insert too ...

Charles Bosquet APISoft FRANCE Received on Mon Sep 18 2000 - 11:12:56 CDT