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

How to get unique records from a table?

512

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

887

---

what are the limitations of identity column? : Transact sql

594

---

Define commit?

537

---

What is data profiling in sql?

507

---

---

what is the difference between blob and text? : Sql dba

518

---

Is sql free?

493

---

How many commands are in sql?

517

---

How many triggers can be applied to a table?

587

---

Explain what is rdbms?

576

---

What are basic techniques of indexing?

835

---

how are mysql timestamps seen to a user? : Sql dba

553

---

Why we use stored procedure instead of query?

525

---

What is the difference between local and global temporary table?

539

---

How do I partition a table in sql?

531

---