Answer Posted / nandkumar

There are bascis 3 difference between them
1> trigger invokes implicitly while we need to invoke
procedure explicitly.
2> We cant pass values from user to trigger but we can pass
values into procedure.
3> Trigger cant return value procedure can return value.

What is sql clause?

996

---

what is a control file ? : Sql dba

991

---

What is the current version of postgresql?

1007

---

What are the operators used in select statements?

1002

---

List and explain the different types of join clauses supported in ansi-standard sql?

1301

---

Explain ttitle and btitle.

1058

---

what are the types of subquery? : Sql dba

1053

---

Which table is left in left join?

956

---

how to calculate the difference between two dates? : Sql dba

996

---

What are properties of the transaction?

958

---

What makes a good primary key?

982

---

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

1219

---

Is pl sql a scripting language?

971

---

Which is faster union or join?

904

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1040

---