Answer Posted / kaushik

If Trigger is written on the table for before insert on
each row then
Trigger will fire first
else
Constraints will fire first.

Vijay Kumar is perfectly right.

How many sql commands are there?

1115

---

Which are the different case manipulation functions in sql?

1023

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1082

---

Does view contain data?

1037

---

What is a design view?

924

---

What are the methods of filing?

935

---

What is nosql vs sql?

1179

---

what are the type of locks ? : Sql dba

966

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

1014

---

How many types of cursors supported in pl/sql?

1193

---

What is sqlexception in java?

993

---

What is a variable in sql?

1002

---

What is having clause in sql?

965

---

How do I remove all records from a table?

1075

---

What is ttitle and btitle?

1065

---