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: S.O.S! Oracle trigger in PL/SQL

Re: S.O.S! Oracle trigger in PL/SQL

From: Angelo Cavallaro <angelo.cavallaro_at_pcm.bosch.de>
Date: 1998/02/18
Message-ID: <34EAB5B7.4B2F@pcm.bosch.de>#1/1

Hello Novita.

> select count(*) into recnum from A_table where
> flight_id=:new.flight_id;

Is this to see if flight_id is updated?
If so, I would write this instead:

	if :new.flight_id != :old.flight_id
	then
	  update ...
	end if;

Greez,
Angelo.

-- 
-----------------------------------------------------------------
Angelo Cavallaro     /  /  /   \     TECTUM Beratungsgesellschaft
ORACLE-SW-Berater   /  /  /     \    für Informationsverarbeitung
ancavall.NOSPAM    /  /  /-------\   Tel: 0711/99073-10
@aol.com          /__/__/_________\  Fax: 0711/99073-99

-----------------------------------------------------------------
	 Visit the Home of the Green Ribbon Campaign:

		http://www.ponce.oisoft.com/

-----------------------------------------------------------------
Received on Wed Feb 18 1998 - 00:00:00 CST

Original text of this message

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