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

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/

-----------------------------------------------------------------