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
What is the best sql course?
If a cursor is open, how can we find in a pl/sql block?
What is the current version of postgresql?
Is inner join faster than left join?
What is the current version of sql?
How do I remove duplicates in two columns?
how to start mysql server? : Sql dba
how to escape special characters in sql statements? : Sql dba
what is dbms? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Can we rollback truncate?
Can we use distinct and group by together?
what is sql server agent? : Sql dba
Do we need to rebuild index after truncate?