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.

Does truncate need commit?

587

---

What is the purpose of design view?

621

---

Is it possible to create startup or shutdown trigger for on-schema?

675

---

how to include numeric values in sql statements? : Sql dba

649

---

What are the benefits of pl/sql packages?

639

---

---

What is the difference between subquery and correlated query?

627

---

Is mariadb nosql?

675

---

How do you declare a variable in pl sql?

632

---

Which data type is a composite type?

629

---

Which is better trigger or stored procedure?

590

---

Can dml statements be used in pl/sql?

674

---

Do we need to rebuild index after truncate?

624

---

What is the difference between sql and isql*plus?

610

---

What is scope of pl sql developer in future?

672

---

What is a clob in sql?

647

---