Interested to Buy Any Domain ? << Click Here >> for more details...
What are nested triggers ?
- 6 Answers
- 33808 Views
- Amazon, Appeal Soft, IBM, Infosys, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subhendu
Triggers are nested when a trigger performs an action that
initiates another trigger, which can initiate another
trigger, and so on. Triggers can be nested up to 32 levels,
and you can control whether triggers can be nested through
the nested triggers server configuration option.
| Is This Answer Correct ? | 52 Yes | 2 No |
Answer / 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.........
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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.
| Is This Answer Correct ? | 4 Yes | 11 No |
Answer / sudipta tripathy
A nested table is a table that appears as a
column in another table.But we can perform
the same operation on it as on other table.
| Is This Answer Correct ? | 2 Yes | 29 No |
Answer / anil_abbireddy
A table is created with in the table is called nested table
| Is This Answer Correct ? | 3 Yes | 33 No |
Which one is better sql or oracle?
What is auto increment feature in sql?
Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?
Why self join is used in sql?
How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?
29 Answers Alps, Aricent, Bank Of America, Wipro,
What is secondary key?
How to call DDL statements from pl/sql?
Explain the steps needed to create the scheduled job?
What is parameter substitution in sql?
What is trigger in pl sql?
Why do we use %rowtype & %type in plsql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
