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: Simple Trigger Question

Re: Simple Trigger Question

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Tue, 27 Jul 2004 22:28:24 +0200
Message-ID: <2jedg0hg2mvdg95v11u6jeqvr41qgtvj9t@4ax.com> 





On 27 Jul 2004 12:48:48 -0700, lduhl_at_corp.realcomp.com (Lee) wrote:



>What do I need to do to the statment above, to make trigger update the

>"UpdateDate" field upon the initial change of the "ImageUrl" field?




pointer : what is the result of comparing a non-null value
(:new.imageurl) to a NULL value (:old.imageurl)?
a) true


b) null





--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Jul 27 2004 - 15:28:24 CDT












Original text of this message













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