SQL> CREATE TABLE to_table
2 (col1 NUMBER);
Table created.
SQL> CREATE OR REPLACE TRIGGER statement_trigger
2 AFTER INSERT ON to_table
3 BEGIN
4 DBMS_OUTPUT.PUT_LINE('After Insert Statement
Level');
5 END;
6 /
Trigger created.
SQL> CREATE OR REPLACE TRIGGER row_trigger
2 AFTER INSERT ON to_table
3 FOR EACH ROW
4 BEGIN
5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level');
6 END;
7 /
Trigger created.
SQL> INSERT INTO TO_TABLE VALUES(1);
After Insert Row Level
After Insert Statement Level
1 row created.
SQL> BEGIN
2 INSERT INTO TO_TABLE VALUES(2);
3 INSERT INTO TO_TABLE VALUES(3);
4 INSERT INTO TO_TABLE VALUES(4);
5 INSERT INTO TO_TABLE VALUES(5);
6 INSERT INTO TO_TABLE VALUES(6);
7 INSERT INTO TO_TABLE VALUES(7);
8 INSERT INTO TO_TABLE VALUES(8);
9 INSERT INTO TO_TABLE VALUES(9);
10 INSERT INTO TO_TABLE VALUES(0);
11 END;
12 /
WAT LL BE THE O/P???
XPLAIN IT>>>>
- 1 Answers
- 3488 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / devraj
The above block will executed successfully.
Because there is no operation performed in any trigger to
use the just inserted rows i mean to say no read and
calcution.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In which language oracle has been developed?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How to create a table interactively?
How do I know if oracle client is installed on windows?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Explain the use of rows option in imp command.
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What the is the diff between local index and global index. give some example.
What is a directory object?
Where do you use decode and case statements?
Explain the use of tables option in exp command.
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What are the numeric comparison operations?
State any two functions of oracle?
How to return top 5 rows in oracle?
