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.

How do I know if oracle is installed on windows?

931

---

What is an oracle table?

988

---

What is procedure overloading in oracle?

1060

---

Explain a private synonyms?

1036

---

What are transaction isolation levels supported by oracle?

1072

---

Explain the use of file option in exp command.

1129

---

What is a subquery in oracle?

1109

---

How do I uninstall oracle 11g?

1117

---

What are a query and state the different types of queries and their uses?

1015

---

 How to use an oracle sequence generator in a mapping?

1074

---

What is an index associated with a constraint?

1040

---

how can we store any pdf file in oracle

2164

---

Is oracle a relational database?

916

---

Why packages are used in oracle?

1066

---

Can we store images in oracle database?

1005

---