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 / mk

Usually the trigger code is in a file e.g. trigger_name.sql

To create/replace the trigger object, at the SQL Plus prompt
type

@<folder>/trigger_name.sql

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are local and global Indexes and where they are useful.

1440


What are % type and % rowtype?

1028


Why is sql important?

1099


What is sql character function?

1070


What is the maximum number of columns in sql table?

1168


What does dml mean?

982


Can we call stored procedure in function?

957


How do I turn a list into a table?

956


How insert into statements in sql?

1067


Does truncate release storage space?

1072


What are the operators in sql?

1025


How do I run sql profiler?

1062


What are expressions?

1009


What is the usage of sql functions?

1144


What is scope of pl sql developer in future?

1017