Re: Create two triggers in the same script.
From: <rtproffitt_at_my-deja.com>
Date: 2000/05/09
Message-ID: <8f9bna$b0f$1_at_nnrp1.deja.com>#1/1
Date: 2000/05/09
Message-ID: <8f9bna$b0f$1_at_nnrp1.deja.com>#1/1
Brian,
[Quoted] When you type the End statement with semi-colon, you are still in the input mode of the editor... Next type Slash '/' to execute your create command. Thus...
END A_Trigger;
/
Show Errors trigger A_Trigger [<- optional]
CREATE OR REPLACE TRIGGER B_Trigger
[etc]
END B_Trigger;
/
Robert Proffitt
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue May 09 2000 - 00:00:00 CEST