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 is an inner join sql?

694


What is pl sql architecture?

681


What is input buffer in sql*plus?

825


how to write date and time literals? : Sql dba

698


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

789






Why is normalization important?

747


what are date and time functions in mysql? : Sql dba

714


What are the types of sql commands?

741


How do we use distinct statement? What is its use?

750


What are triggers in sql?

749


how to get @@error and @@rowcount at the same time? : Sql dba

739


how to see the create table statement of an existing table? : Sql dba

734


What is sql indexing?

754


Which table is left in left join?

715


What is the usage of distinct keyword?

815