Answer / neelu

Yes.

create or replace trigger trg_test
before insert on emp
begin
null;
end;

create synonym trg_syn for trg_test;

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;
/

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.

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.

How can you create an empty table from an existing table?

0 Answers  

---

What is difference between stored function and application function?

0 Answers  

---

what is the difference between join and union? : Sql dba

0 Answers  

---

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

---

What is recursive join in sql?

0 Answers  

---

How can we optimize a sql query?

0 Answers  

---

What is materialized view in sql?

0 Answers  

---

what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,

---

what is a view? : Sql dba

0 Answers  

---

how many columns can be used for creating index? : Sql dba

0 Answers  

---