Answer Posted / 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;
/

What is application trigger?

552

---

How do you identify a primary key?

639

---

what is 'trigger' in sql? : Sql dba

570

---

What is a schema? How is it useful in sql servers?

601

---

Explain normalization and what are the advantages of it?

521

---

---

What is native sql query?

563

---

what is transaction? : Sql dba

539

---

Why do we need databases?

576

---

Explain the structure of pl/sql in brief.

628

---

How do I kill a query in postgresql?

561

---

is it possible to pass an object or table to a procedure as an argument?

585

---

What is difference between pls_integer and integer?

525

---

How do you copy a table in sql?

572

---

What is procedure and function?

524

---

Can you join views in sql?

553

---