Oracle Discussion Forums
Welcome, Guest. Please login or register.
September 10, 2010
Home Help Search Login Register
News:


+  WebForums - OraclePassport
|-+  IT progamming - Oracle, Java, Unix, MySQL, Toad
| |-+  Oracle -Triggers, Exceptions, Procedures
| | |-+  Oracle Triggers
| | | |-+  Is before delete trigger fired on truncated table?		 0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Send this topic Print
Author Topic: Is before delete trigger fired on truncated table?  (Read 936 times)
dtech-team
Administrator
Assistant Professor
*****

Appreciate? +5/-0
Offline Offline

Posts: 616


DTecH Oracle Forums

WWW
« on: April 14, 2009 »
Is before delete trigger fire on truncated table?

Changing to question to:

Is a Delete trigger fired when the table, on which the trigger is associated, is TRUNCATED?
« Last Edit: March 29, 2010 by sippsin » Report to moderator   Logged

DTecH Admin Team
Buy Oracle Interview Preparations Kit from DTecH IT Education - 250 Oracle Interview Questions and Answers.
kushi
Professional
****

Appreciate? +7/-0
Offline Offline

Posts: 140
« Reply #1 on: April 14, 2009 »
No delete trigger will not fire when table is truncated
« Last Edit: March 29, 2010 by sippsin » Report to moderator   Logged
Kushi
sibanjan
Trainer
****

Appreciate? +6/-0
Offline Offline

Posts: 51


Welcome!
« Reply #2 on: March 29, 2010 »
Triggers cannot be used with DDL  and select statements.Only DML statments(insert,update and delete) and database events like logon,logoff causes triggers to fire   :)
« Last Edit: March 29, 2010 by sippsin » Report to moderator   Logged
Pages: [1] Go Up Send this topic Print 
« previous next »
 
Share this topic...
In a forum
(BBCode)
In a site/blog
(HTML)



Login with username, password and session length

Powered by MySQL Powered by PHP Powered by SMF 2.0 RC1.2 | SMF © 2006–2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Page created in 0.429 seconds with 20 queries.