can i create trigger on synonym is it possible or not please help me

Answer Posted / shailesh

Yes, the trigger can be created on synonym. However, this trigger gets created on the respective base table for which the synonym is created.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is union and union all keyword in sql and what are their differences?

587


What is a loop in sql?

576


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

669


What is a join?

634


Explain two easy sql optimizations.

609






What are the types of keys?

518


How many types of cursors are available in pl/sql?

592


What are sql injection vulnerabilities?

504


what is query cache in mysql? : Sql dba

585


who introduced sql?

574


How do I make my sql query run faster?

475


Does execute immediate commit?

704


Define union, minus, union all, intersect ?

559


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

537


What is sql not null constraint?

615