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

What is the usage of analyze command in oracle?

1093

---

How to join two tables in a single query using oracle?

997

---

How can windows applications connect to oracle servers?

1057

---

does the query needs a hint to access a materialized view?

1857

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

---

How view is different from a table?

1035

---

Describe the types of sub query?

997

---

State the various uses of dbcc command?

1060

---

Explain what are synonyms used for?

1034

---

What are the uses of Database Trigger ?

1720

---

Difference between open_form and call_form in oracle.

1161

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

---

What is the difference between hot backup and cold backup in oracle?

1014

---

Explain a segment?

1086

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2022

---