Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Use a trigger to remove NULL values?

Re: Use a trigger to remove NULL values?

From: Martijn Tonies <m.tonies_at_upscene.removethis.com>
Date: Wed, 8 Feb 2006 16:06:44 +0100
Message-ID: <11uk28ie2chqg42@corp.supernews.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 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.com



> 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
>
Received on Wed Feb 08 2006 - 09:06:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US