Answer / kiran r

Triggers are classified as follows
1. Based on Trigger level
Row level Trigger and Statement level trigger
2. Based on time
Before, after, Instead
3. Based on Event
DDL, DML,Database Trigger

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

0 Answers  

---

What is difference between cursor and ref cursor?

1 Answers  

---

What is sql profiling in oracle?

0 Answers  

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---

Explain the working of foreign key?

0 Answers  

---

---

Are stored procedures faster than queries?

0 Answers  

---

How to select unique records from a table?

0 Answers  

---

What are the different tcl commands in sql?

0 Answers  

---

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,

---

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

---

What is sql procedures and functions?

0 Answers  

---

What are different types of keys?

0 Answers  

---