Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Use a trigger to remove NULL values?
> 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 NULL shouldn't be inserted, then I guess this could be thought of as an error in the application. If the application is not at fault, or this is out of your hands, then yes, I think a trigger would be the way to go.
-- Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.comReceived on Wed Feb 08 2006 - 09:06:44 CST
> 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
>