Re: triggers
From: Donna Kray <kray.donna_at_mlink.motors.ge.com>
Date: 1996/02/01
Message-ID: <4eqjlr$nhp_at_crissy.ge.com>#1/1
Date: 1996/02/01
Message-ID: <4eqjlr$nhp_at_crissy.ge.com>#1/1
Heather Dyson <dyson_at_template.com> wrote:
>
>I need to create a trigger in the database but
>it doesn't seem to be accepting it. I am using
>sqlplus. Can anyone tell me where I am going
>wrong?
>
>CREATE TRIGGER update_trig
>BEFORE
>UPDATE
>ON table
>BEGIN
> INSERT INTO table2
> VALUES(new.field, 1);
>END update_trig;
>
>Sqlplus just waits for more input.
>
>Thanks,
>Heather
Now all you need to do is enter a slash (/) on a line by itself. That will execute the PL/SQL block. You need this slash in a script as well.
DL Kray Received on Thu Feb 01 1996 - 00:00:00 CET