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 can use stored procedures in sql?

574

---

how many ways to get the current time? : Sql dba

522

---

Where do we use pl sql?

545

---

Can we create clustered index without primary key?

517

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

802

---

---

How do I start sql profiler?

550

---

How does cross join work in sql?

529

---

How do you truncate?

498

---

What is #table in sql?

515

---

How to avoid duplicate records in a query?

575

---

What is Materialized View? In What Scenario we Use Materialized View?

8507

---

What are types of indexes in sql?

534

---

What makes a good primary key?

516

---

How to get each name only once from an employee table?

602

---

Does inner join return duplicate rows?

516

---