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 does the t-sql command ident_current does? : Transact sql

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

Sql technical questions

0 Answers  

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

0 Answers  

---

What are the different types of joins in sql?

3 Answers  

---

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---

Why indexing is needed?

0 Answers  

---

how to create temparary sequence

2 Answers   TCS,

---

Explain dml and ddl?

0 Answers  

---

What is auto increment feature in sql?

0 Answers  

---

What is character functions?

0 Answers  

---

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

---