How to call a trigger inside a stored procedure?Give an
example.

Answer Posted / jay

Inside procedure, insert/update/delete the row in table.
The table will automatically fire the trigger. Trigger will
get fire automatically.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do we represent comments in oracle?

600


What happens to the current transaction if the session is killed?

504


How can we create the complete backup of data in the oracle.

1660


What happens if the imported table already exists?

524


what is the difference between restoring and recovering?

530






What are group functions in oracle?

557


Does oracle charge for java?

555


What is the difference between post-database commit and post-form commit?

491


Can group functions be mixed with non-group selection fields?

510


Differentiate between post-database commit and post-form commit?

516


What is an oracle data file?

584


What privilege is needed for a user to create indexes in oracle?

552


What is enter substitution variable in oracle?

545


What is the difference between alert log file and tarce file ?

1612


How to create a single index for multiple columns?

541