Answer Posted / s. elaiyaraja

The Main difference between stored procedure and Function
is SP's can return the value or not, but Functions should
return the value.

And We can use the function within the Queries, but sp's we
won't able to use it in the queries.

We can implicitely execute the sp's. But function's we
can't.

What are nested tables?

669

---

Why oracle is used?

578

---

What is the relation of a user account and a schema?

611

---

How to retrieve values from data fields in record variables?

563

---

How do I uninstall oracle client from windows?

534

---

---

How to speed up webrick?

591

---

How to export your own schema?

569

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1440

---

What is difference between cartesian join and cross join?

582

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1280

---

What is an oracle recycle bin?

548

---

How can Oracle users be audited?

601

---

How can we find out the current date and time in oracle?

641

---

Does oracle charge for java?

586

---

How would you go about verifying the network name that the local_listener is currently using?

1602

---