Answer / manikandan. s

triggers can't be called from procedures or functions

Answer / jay

Inside procedure, insert/update/delete the row in table.
The table will automatically fire the trigger. Trigger will
get fire automatically.

Is oracle a relational database?

0 Answers  

---

What is an oracle transaction?

0 Answers  

---

Briefly explain what is literal? Give an example where it can be used?

0 Answers  

---

What are the extensions used by oracle reports?

0 Answers  

---

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

---

Explain the use of rows option in exp command.

0 Answers  

---

Calculate difference between 2 date / times in oracle sql?

0 Answers  

---

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

2 Answers   Verizon,

---

what is the uses of cusor

3 Answers   Perot Systems,

---

What is varray?

0 Answers  

---

Explain the difference between sap and oracle?

0 Answers  

---

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

0 Answers  

---