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
- 4507 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 the use of triggers in Java program? I mean where do we use triggers in Java programming?
Explain the difference between replace() and translate() functions in oracle?
How to rebuild an index in oracle?
What types of joins are used in writing subqueries?
Which environment variables are absolutely critical in order to run the OUI?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is a cognitive schema?
What is the order of defining local variables and sub procedures/functions?
What is logical backup in oracle?
How do you tell what your machine name is and what is its IP address?
What is a relational database management system?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Describe the types of sub query?
