Answer Posted / roopesh kumar

Diff. B/W Procudure & Func......
(1) Proc. may or may not return value or more than one.
but func. must return a single value.
(2) We can call a func. in a select stmt. but func. should
only with IN parameter.
But we can't call a procedure inside a selct stmt.
because calling a procedure itself a PL/SQL block.

There is no too much diff. b/w proc. & func. but the thing
is that when we are looking to get back a single value we
should use func. in case of more than one then we should go
for proc.

Diff. b/w proc. & trigger..

(1) We have to call a proc. explicitly but trigger will
fire implicitly with assosiated event.

What is difference between stored procedures and application procedures?

956

---

What is the difference between rollback and rollback to statements?

1013

---

what is the syntax for using sql_variant_property? : Transact sql

987

---

How much does sql cost?

930

---

how to drop an existing index in mysql? : Sql dba

1017

---

Do prepared statements prevent sql injection?

897

---

Which operator is used in query for pattern matching?

1032

---

How do I filter in sql profiler?

947

---

How to take user input in pl sql?

1106

---

Why procedure is used in sql?

969

---

what is self join and what is the requirement of self join? : Sql dba

1076

---

What does dml mean?

927

---

Is merge a dml statement?

922

---

What is the primary use of normalization?

941

---

What are sql indexes?

934

---