adspace


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

Can we use distinct and group by together?

1143


Can delete statement be rollbacked?

1061


Do we need to rebuild index after truncate?

1149


what is collation? : Sql dba

1235


What is the current version of postgresql?

1185


What is the best sql course?

1057


what are aggregate and scalar functions? : Sql dba

1137


How do I remove duplicates in two columns?

1198


What is your daily office routine?

2351


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2097


what are the advantages of sql ? : Sql dba

1148


how many tables will create when we create table, what are they? : Sql dba

1151


What is the current version of sql?

1100


If a cursor is open, how can we find in a pl/sql block?

1249


what is bcp? When does it used? : Sql dba

1063