Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> using nvl when insert or update
I know I can do this if I explicitly call it, but Id like to automate
it.
If for some reason someone adds a null value to a field, Id like to change it with a nvl to 0. I dont want an error to come back. The field will be in the same table that is being inserted or updated so I cant use a trigger.
Anyway to automate this? Received on Mon Mar 11 2002 - 10:17:46 CST