Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Use a trigger to remove NULL values?
"CJ" <christian.juell_at_gmail.com> wrote in message
news:1139410926.260236.113560_at_g43g2000cwa.googlegroups.com...
>I am having some issues with an application that enters NULL values to
> an oracle 9.2 db. The application inserts multiple rows with NULL,
> which are currently removed by using standard SQL (delete) on two
> tables (table a contains the value, table b contains the relation).
>
> I therefore wonder if this would be an appropriate place to use a
> trigger?
> If yes, any examples or suggestion on how to do this?
> If no, what would be the appropriate way of automatic cleaning up this
> problem? (I can not rewrite the application)
>
> Regards,
> CJ
>
how about NOT NULL constraints on the appropriate columns?
++ mcs Received on Wed Feb 08 2006 - 09:12:11 CST