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
How can use stored procedures in sql?
how many ways to get the current time? : Sql dba
Where do we use pl sql?
Can we create clustered index without primary key?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
How do I start sql profiler?
How does cross join work in sql?
How do you truncate?
What is #table in sql?
How to avoid duplicate records in a query?
What is Materialized View? In What Scenario we Use Materialized View?
What are types of indexes in sql?
What makes a good primary key?
How to get each name only once from an employee table?
Does inner join return duplicate rows?