Home » Developer & Programmer » Forms » Can we disable just one of many triggers on a table ?
Can we disable just one of many triggers on a table ? [message #77986] Sat, 29 December 2001 17:10 Go to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: Re: Connection between Oracle 8i enterprise 8.1.5and Forms Builder
Next Topic: Control to customised menus
Goto Forum:
  


Current Time: Thu Mar 28 13:13:13 CDT 2024