PL/SQL - How to disable a trigger for a particular table ?

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 170 of 241

How to disable a trigger for a particular table ?

Suppose if i have 8 triggers declared for a table..how to disable a single trigger from a table...
i don't want to disable all triggers for a table. I know we can disable all triggers by using "alter table disable all triggers;". just i want to know how to disable single trigger from a table.

Total Answers and Comments: 3

Last Update: April 03, 2007 Asked by: Pavan

Sponsored Links

Best Rated Answer

—

Submitted by: Pervez

use following statement
alter trigger <trigger_name> disable

Above answer was rated as good by the following members:
manish.baehal, radheshyambidada

March 23, 2007 02:18:23

Pervez

RE: How to disable a trigger for a particular table ?

use following statement
alter trigger <trigger_name> disable

Is this answer useful? Yes | No

2 0