| Can we disable just one of many triggers on a table ? [message #77986] |
Sat, 29 December 2001 17:10  |
Befuddled
Messages: 1
Registered: December 2001
|
Junior Member |
|
|
Hi ,
I recently came across an MCQ in an OCP - SQL & PL/SQL book. The question was about disabling a trigger TEMP_TRIG temporarily prior to a data upload on a table MYTABLE.
Two of the answer choices were :
(a) alter table MYTABLE disable all triggers ;
(b) alter table MYTABLE disable TEMP_TRIG ;
The correct answer turned out to be choice (a) !!
Is this correct ? Would this not disable even other required triggers on MYTABLE while uploading data ?
Is it not possible to disable just one trigger on a table ???
----------------------------------------------------------------------
|
|
|
|
| Re: Can we disable just one of many triggers on a table ? [message #77991 is a reply to message #77986] |
Sun, 30 December 2001 22:50  |
Tamim
Messages: 23
Registered: October 2001
|
Junior Member |
|
|
Yes, you can disable only one trigger on a table but the problem is the 2nd answer is wrong as the syntax is wrong.
You can disable a trigger by using the following -
alter trigger temp_trig disable
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
