Answer Posted / suresh

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

How to recover a dropped table in oracle?

990

---

How to use attributes of the implicit cursor in oracle?

963

---

What is memory advisor in Oracle?

1033

---

What is the difference between online and offline backups?

993

---

How does one get the view definition of fixed views/tables?

975

---

How do I know if oracle is installed on windows?

889

---

Why we use bulk collect in oracle?

984

---

Can you assign multiple query result rows to a variable?

939

---

How to write an inner join with the where clause in oracle?

1016

---

How to view the data files in the current database?

1052

---

What is an oracle user role?

945

---

What is oracle server autotrace in oracle?

1102

---

How do you store pictures in a database?

963

---

How to build data dictionary view an new database?

968

---

How to define a sub function?

1096

---