can i create trigger on synonym is it possible or not please help me
Answers were Sorted based on User's Feedback
Answer / neelu
Yes.
create or replace trigger trg_test
before insert on emp
begin
null;
end;
create synonym trg_syn for trg_test;
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / 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 |
Answer / akhil
hi neelu.
question is "Can I trigger on synonym'
but you have answered for the question "Can I create synonym for trigger"(your answer is correct for this question)
my understanding about the real question is
we have create synonym for the table,then is it possible to create trigger on that synonym.
If my understanding is wrong,forgive me.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shailesh
Yes, the trigger can be created on synonym. However, this trigger gets created on the respective base table for which the synonym is created.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is the difference between blob and text? : Sql dba
What is multiple columns?
What is a left inner join?
What are the two virtual tables available at the time of database trigger execution?
What is sql table?
Is sql pronounced sequel or sql?
How is indexing done in search engines?
What is meaning of <> in sql?
create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?
What is the difference between left join and right join?
How do temporal tables work?
how to install mysql? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)