Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is query syntax?

969


What is pl sql in dbms?

949


What is sql data?

995


How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1096


What is cold data?

960


what tools available for managing mysql server? : Sql dba

1085


What is the requirement of self-join?

1132


Is time a data type in sql?

906


Is t sql a programming language?

1065


what is view? : Sql dba

959


what's the difference between a primary key and a unique key? : Sql dba

1050


What is rename in sql?

973


How many functions are there in sql?

1024


what are the advantages of sql ? : Sql dba

1060


What is trigger with example?

1099