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 many developers work on postgresql?

0 Answers  

---

How do you define a foreign key?

0 Answers  

---

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

What is the difference between clustered and non-clustered index in sql?

0 Answers  

---

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 Answers  

---

What is cursor in pl sql?

0 Answers  

---

Can we call a function containing dml statements in a select query?

0 Answers  

---

What is the difference between delete, truncate and drop command?

0 Answers  

---

How to return more than one value from a function?

11 Answers   Satyam,

---

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers   Pitney Bowes,

---

Can we have two clustered index on a table?

0 Answers  

---

What is graph sql?

0 Answers  

---