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: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 8 Feb 2006 10:12:11 -0500
Message-ID: <xtGdnRX4idfRl3feRVn-rg@comcast.com>

"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

Original text of this message

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