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

Does facebook use oracle?

1084

---

What are the data types in oracle?

1096

---

Explain the use of consistent option in exp command.

1140

---

Does oracle database need java?

1067

---

definition of cluster and non-clustered index?

3101

---

candidate key is subset of super key but not vice-verse explain

2106

---

How to update a table row with a record?

1065

---

What are the database administrators utilities available?

1096

---

Explain implicit cursor.

1075

---

What is a private synonym?

1644

---

What is a system tablespace and when it is created?

1015

---

How to assign query results to variables?

1096

---

How to define a data source name (dsn) in odbc manager?

1081

---

Explain user account with reference to oracle.

1029

---

What is a nvl function?

1096

---