The above block will executed successfully. Because there is no operation

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>>>>

Question Posted / devraj

1 Answers
4312 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

Please Help Members By Posting Answers For Below Questions

What are the tools for Oracle ?

1007

State and explain the different types of data models?

893

What are the general rules on data consistency?

956

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2173

Why packages are used in oracle?

1000

What is a cursor and what are the steps need to be taken?

1116

What would you do with an in-doubt distributed transaction?

1914

What is Data Dictionary Cache in Oracle?

1117

what is normalisation?what are its uses?

2207

How to get last row id?

938

How do I start tns listener?

987

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2901

what is IDE,DMV in sql server?

2752

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1936

What is ceil and floor in oracle?

1006