OraFAQ Forum: SQL & PL/SQL » how can i create a trigger before insert into a table

Home » SQL & PL/SQL » SQL & PL/SQL » how can i create a trigger before insert into a table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can i create a trigger before insert into a table [message #1434]

Tue, 30 April 2002 07:08

smichi
Messages: 4
Registered: April 2002

Junior Member

hello ,
Could you please help me ;
i don't knew how to create a trigger before inseration of a new row in a tabel (the syntax) .
thank for any help

Report message to a moderator

Re: how can i create a trigger before insert into a table [message #1436 is a reply to message #1434]

Tue, 30 April 2002 07:50

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

create or replace trigger sample_trigger
before insert on emp
for each row
begin
...
...
...
dbms_output.put_line('sample trigger fired. the row inserted is '||:new.empno);
end;

Report message to a moderator

Re: how can i create a trigger before insert into a table [message #2650 is a reply to message #1434]

Sat, 03 August 2002 13:11

duh
Messages: 1
Registered: August 2002

Junior Member

bloody goof

Report message to a moderator

Previous Topic:	SQL query problem - help needed pls
Next Topic:	Re: users

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 10 06:00:06 CDT 2024