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 code pages ?

1 Answers   BirlaSoft,

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

Why do we use joins?

0 Answers  

---

What is the cause of mutating table error and how can we solve it?

0 Answers  

---

What type of database is cloud sql?

0 Answers  

---

what is a primary key? : Sql dba

0 Answers  

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

0 Answers  

---

how to get help information from the server? : Sql dba

0 Answers  

---

How do you use collections in procedure to return the resultset?

0 Answers  

---

How can we avoid duplicating records in a query?

0 Answers  

---

Can a procedure in a package be overloaded?

0 Answers   EXL,

---

How to select 10 records from a table?

0 Answers  

---