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

Answer Posted / neelu

Yes.

create or replace trigger trg_test
before insert on emp
begin
null;
end;

create synonym trg_syn for trg_test;

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to look at the current sql*plus system settings?

682


How do I partition a table in sql?

625


what are the 'mysql' command line options? : Sql dba

647


The select into statement is most often used to create backup copies of tables or for archiving records?

666


Why do we use triggers?

620






Is crud a cuss word?

680


What is dml with example?

604


What are aggregate and scalar functions?

612


Can we use two order by clause in query?

642


define join and explain different type of joins? : Sql dba

641


What is the best partition size for windows 10?

606


explain the delete statements in sql

665


What is the main difference between sql and pl/sql?

647


how to convert character strings to dates? : Sql dba

611


What is rownum and rowid?

655