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

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1638


How many types of triggers exist in pl/sql?

561


What are keys in sql?

546


Which is faster union or join?

491


What is primary key and foreign key with example?

494






Can you rollback after commit?

524


What is a .db file?

538


What is row_number () in sql?

539


explain mysql aggregate functions. : Sql dba

545


What is mutating trigger?

576


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

545


what is the functionality of the function htmlentities? : Sql dba

519


What is hibernate and its relation to sql?

591


What is a rank in sql?

534


What is sql performance tuning?

492