How to recompile a already made trigger?

Answer Posted / chandrakant agrawal

To recompile Trigger:
ALTER TRIGGER <trigger_name> COMPILE;
The trigger can be enabled and disabled manually by using:

Alter Table <table_name> disable(enable) all trigger;

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how is exception handling handled in mysql? : Sql dba

549


Is sql sequential or random?

536


Is ms sql is free?

526


Is sql an operating system?

543


How can one get sql*loader to commit only at the end of the load file? : aql loader

563






What are tables in sql?

547


Can a key be both primary and foreign?

508


How can you load multi line records? : aql loader

655


Why is sql better than hql?

504


What is pl sql block structure?

539


how to get a list of columns in an existing table? : Sql dba

540


Can you have a foreign key without a primary key?

507


what are the advantages a stored procedure? : Sql dba

544


What is data abstraction in sql?

510


Is sqlexception checked or unchecked?

535