Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: using nvl when insert or update
ALTER TABLE mytable
MODIFY (mycolumn DEFAULT 0);
No triggers, no NVL, no code, no hassles.
Daniel Morgan
Ryan Gaffuri wrote:
> 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 - 11:33:50 CST