adspace


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

Answer Posted / suman

Yes u can create trigger on synonym
below are example
select * from scott.emp;

select * from sy_emp;
create or replace synonym sy_emp for scott.emp;

/
create or replace trigger t_name
after insert on sy_emp
begin
null;
end;
/

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the best sql course?

1057


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

1249


What is the current version of postgresql?

1185


Is inner join faster than left join?

1284


What is the current version of sql?

1100


How do I remove duplicates in two columns?

1198


how to start mysql server? : Sql dba

1275


how to escape special characters in sql statements? : Sql dba

1122


what is dbms? : Sql dba

1067


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

1151


how to use regular expression in pattern match conditions? : Sql dba

1119


Can we rollback truncate?

1080


Can we use distinct and group by together?

1143


what is sql server agent? : Sql dba

1186


Do we need to rebuild index after truncate?

1149