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 is bulk bind

4 Answers   TCS,

---

What is function and procedure in pl sql?

1 Answers  

---

What does over partition by mean in sql?

1 Answers  

---

How do I copy a table in sql?

1 Answers  

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1 Answers  

---

What is pl/sql tables?

7 Answers   TCS,

---

What is asqueryable?

1 Answers  

---

Define commit?

1 Answers  

---

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

1 Answers  

---

How do I create a sql script?

1 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

Explain spool.

1 Answers  

---