Re: create trigger use sql*plus
From: Brian W. Chester <bwchester_at_home.com>
Date: Fri, 18 Feb 2000 17:24:42 GMT
Message-ID: <uffr4.8486$a27.191945_at_news1.rdc1.mb.home.com>
Date: Fri, 18 Feb 2000 17:24:42 GMT
Message-ID: <uffr4.8486$a27.191945_at_news1.rdc1.mb.home.com>
Could you show us what you were doing? It help point out where the problem is!
The syntax is:
CREATE or REPLACE TRIGGER schema.trigger_name
BEFORE/AFTER/INSTEAD OF DELETE or INSERT or UPDATE OF column_name
ON schema.table_name/view_name
REFERENCING clause
WHEN ( condition )
PL/SQL block;
HTH Brian.
"nice to see you" <moz01_at_holmes.ipfw.edu> wrote in message
news:Pine.HPX.4.10.10002181136460.5889-100000_at_holmes.ipfw.edu...
>
> Hi, is anyone know how to use sql*plus to create trigger? I tried it. It
> just keep give line numbers.
>
> Thank you.
>
Received on Fri Feb 18 2000 - 18:24:42 CET