Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4451 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
What is bind variable in oracle 11g?
What is sharded cluster?
What are the extensions used by oracle reports?
Please explain oracle data types with examples?
Does oracle database need java?
How to define an anonymous procedure with variables?
What are ddl statements in oracle?
Explain database link?
What is oracle in java?
What is the best way to do multi-row insert in oracle?
How to get execution statistics reports on query statements?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What are privileges and grants?
Design database draw er diagram for a certain scenario ?
How to define a procedure inside another procedure?
