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.

Show code of a cursor for loop.

0 Answers  

---

What does the base_object_type column shows in the user.triggers data dictionary view?

0 Answers  

---

What is PL/SQL table ?

6 Answers  

---

What is query optimization in sql?

0 Answers  

---

Can we create table in function?

0 Answers  

---

---

Is left join faster than join?

0 Answers  

---

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

---

How do I create a sql script?

0 Answers  

---

What is online transaction processing (oltp)?

0 Answers  

---

What are database links used for?

0 Answers  

---

Which is faster subquery or join?

0 Answers  

---

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

---