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 types of commands can be executed in sql*plus?
What is data abstraction in sql?
What is union and union all keyword in sql?
What is an exception in PL/SQL? What are the two types of exceptions?
Explain architecture of sql server notification services?
Is primary key an index?
What is pl sql quora?
What is difference between pl and sql?
What is multiple partition?
How do I view output in sql developer?
What is crud stand for?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is microsoft t sql?
Is sql a backend?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba