Replacing a date with blank

[anniez]

I have a trigger that, if it finds a matching record to update, puts in the current data.
There is a date field that should be made blank. Can you help me with the syntax?
set
a=:new.a,
b=:new.b,
dscdate = ?????
where id=:new.id;

 

[lewisp]

dscdate = NULL;

 

[anniez]

I should have been more specific. It will only be null if the unitID starts with 3. I have:

dscdate = decode(substrnew.unitID,1,1),3,NULL)


it doesn't work. Thanks

 

[sem]

So why don't you use DECODE (you may use select from dual)? Or just if then else?

Regards, Dima

 

[ChrisHunt]

IF SUBSTRnew.unitID,1,1)='3' THEN
dscdate := NULL;
END IF;

-- Chris Hunt
Extra Connections Ltd

http://www.extracon.com

The real world's OK for a visit, but you wouldn't want to LIVE there!