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
- 4328 Views
- Infosys, I also Faced
- E-Mail Answers
Answer / 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 |
What is difference between Rename and Alias?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
Explain the use of file option in exp command.
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
what is query and types of query
Explain what are the different type of segments?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is difference between truncate and delete?
How to use existing values in update statements using oracle?
How many types of synonyms in Oracle?
How do you handle duplicate records in a database?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
Oracle General 
