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

Can we call procedure in select statement?

1111

---

Why do we use sql constraints?

1215

---

How can check sql version from command line?

1138

---

If a cursor is open, how can we find in a pl/sql block?

1215

---

What is optimistic concurrency control? : Transact sql

1030

---

What is the location of pre_defined_functions.

1209

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1086

---

What does subquery mean in sql?

1114

---

what is sql? : Sql dba

1071

---

What is the use of sqldataadapter?

1026

---

Which are sql * plus commands?

1203

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2163

---

What company owns postgresql?

1090

---

What is type and rowtype in pl sql?

1057

---

what is the functionality of the function htmlentities? : Sql dba

1006

---