Answer / Khubendra Pratap Sant

There are three main types of SQL triggers: AFTER triggers, which fire after a DML operation; BEFORE triggers, which fire before a DML operation; and INSTEAD OF triggers, which replace the action of an event.

Can we commit inside a trigger?

1 Answers  

---

What is the use of double ampersand (&&) in sql queries? Give an example

1 Answers  

---

How can I delete duplicate rows?

1 Answers  

---

what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,

---

Can we join two tables without common column?

1 Answers  

---

What is a loop in sql?

1 Answers  

---

How global cursor can be declare with dynamic trigger ?

1 Answers  

---

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

---

Show the two pl/sql cursor exceptions.

1 Answers  

---

What is dense_rank in sql?

1 Answers  

---

What is primary key and foreign key with example?

1 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1 Answers  

---