Answer Posted / srikanth

A trigger that contains data modification logic within
itself is called a nested trigger.

Use the nested triggers option to control whether an AFTER
trigger can cascade; that is, perform an action that
initiates another trigger, which initiates another trigger,
and so on. When nested triggers is set to 0, AFTER triggers
cannot cascade. When nested triggers is set to 1 (the
default), AFTER triggers can cascade to as many as 32
levels. INSTEAD OF triggers can be nested regardless of the
setting of this option.

What is sql architecture?

1048

---

Why we use joins in sql?

982

---

what is innodb? : Sql dba

1105

---

Which nosql database is best?

975

---

Can we call a function containing dml statements in a select query?

978

---

Does varchar need length?

991

---

Can a composite key be null?

978

---

What is server name sql?

1143

---

Is primary key an index?

991

---

What is the difference among union, minus and intersect?

1000

---

What are inner and outer joins examples of both?

960

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

---

how to shutdown mysql server? : Sql dba

1102

---

What are stuff and replace function?

1081

---

What is record type in pl sql?

993

---