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 wrote:
> 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
Fix the application. Treat the disease. Not the symptom.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Wed Feb 08 2006 - 11:14:18 CST