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 are the differences between char and nchar? : Sql dba
Are null values same as that of zero or a blank space?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What is sql injection owasp?
What is a nested table in word?
What is left join in postgresql?
Is sql a dbms?
Is ms sql traffic encrypted?
What is sql server and ase?
What is the command used to fetch the first 5 characters of a string?
What are the different types of database management systems?
What is normalisation and its types?
Is time a data type in sql?
How do I run sql?
What is parallel hint?