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 values can the set function of mysql take? : Sql dba

0 Answers  

---

what is the difference between truncate and delete statement? : Transact sql

0 Answers  

---

What are the operators used in select statements?

0 Answers  

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  

---

What are different clauses used in sql?

0 Answers  

---

---

What is difference between pls_integer and integer?

0 Answers  

---

What is Data Concarency and Consistency?

1 Answers  

---

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

0 Answers  

---

Explain what is dbms?

0 Answers  

---

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

---

what is the difference between where clause and having clause? : Sql dba

0 Answers  

---