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.

What are the subsets of sql?

0 Answers  

---

what is the difference between delete and truncate commands? : Sql dba

0 Answers  

---

What is sql entity?

0 Answers  

---

How did you export data from database to excel file.

1 Answers   TCS,

---

What are sql built in functions?

0 Answers  

---

How do you break a loop in pl sql?

0 Answers  

---

What is a common use of group by in sql?

0 Answers  

---

What are the various restrictions imposed on view in terms of dml?

0 Answers  

---

What is the difference between the implicit and explicit cursors?

0 Answers  

---

Can we call procedure in select statement?

0 Answers  

---

How can I make sql query run faster?

0 Answers  

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---