| trigger [message #71810] |
Wed, 15 January 2003 13:48  |
Pratibha
Messages: 29
Registered: November 2001
|
Junior Member |
|
|
It means
I can't update any row ,after creating 'before update trigger'.Is this right?
like this,If I create 'before insert 'trigger,here,I
can't insert any value.Is this right
thank you.
|
|
|
|
| Re: trigger and please maintain a single thread [message #71811 is a reply to message #71810] |
Wed, 15 January 2003 14:08  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
NO.
You create a trigger that fires under a particular event.
if you create a before insert trigger,
the trigger is fired BEFORE THE RECORD is inserted.
Thats it.
SQL> create or replace trigger bef_in_ddd
2 before insert on ddd
3 for each row
4 begin
5 dbms_output.put_line('before insert trigger fired');
6 end;
7 /
Trigger created.
SQL> ed
Wrote file afiedt.buf
1 create or replace trigger after_in_ddd
2 after insert on ddd
3 for each row
4 begin
5 dbms_output.put_line('after insert trigger fired');
6* end;
SQL> /
Trigger created.
SQL> set serveroutput on
SQL> insert into ddd values ('sample');
before insert trigger fired
after insert trigger fired
1 row created.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
