Answer Posted / sunil kumar

Nested triggers are fired due to actions of other triggers.
For example, you delete a row from TableA. A trigger on
TableA deletes row from TableB. Because you are deleting
rows from TableB,a trigger is executed on TableB to record
the deleted row is called nested trigger.........

How do I debug a stored procedure?

1108

---

What is the process of debugging?

1061

---

What are sql triggers used for?

989

---

What are the two types of exceptions in pl/sql?

1047

---

What are types of joins?

963

---

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

1085

---

Why functions are used in sql?

988

---

How to fetch alternate records from a table?

1227

---

Is sqlexception checked or unchecked?

960

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2076

---

what is timestamp in mysql? : Sql dba

1069

---

What are the sql commands?

1168

---

What is information schema in sql?

1067

---

What is the difference between a procedure and a function?

1101

---

How to take user input in pl sql?

1159

---