Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't terminate CREATE TRIGGER command
CREATE OR REPLACE TRIGGER DriverTrig
BEFORE INSERT ON Driver
FOR EACH ROW
BEGIN
SELECT DriverSeq.NEXTVAL INTO :NEW.ID FROM dual;
END;
/ <--
Hth,
Sybrand Bakker, Oracle DBA
Just to make sure the 'arrow' is unnecessary
Svend Meyland Nicolaisen <nicolaisen_at_my-deja.com> wrote in message
news:7q6jnm$u1k$1_at_news.cybercity.dk...
> When I enter the following SQL command in SQL*Plus, SQL*Plus just keeps
> asking for the next line. No matter what I write Oracle doesn't execute
the
> command.
>
>
> CREATE OR REPLACE TRIGGER DriverTrig
> BEFORE INSERT ON Driver
> FOR EACH ROW
> BEGIN
> SELECT DriverSeq.NEXTVAL INTO :NEW.ID FROM dual;
> END;
>
>
Received on Fri Aug 27 1999 - 13:13:17 CDT