Answer Posted / abhirup roy

In The above answers all the major differences have been disclosed, with one wrong information.
We can call a procedure from a function and vice-versa (as long as the function and procedure has same/similar scope).
In order to defend my point I am posting one small code below for reference.
DECLARE
PROCEDURE my_proc;
FUNCTION my_func RETURN NUMBER IS
BEGIN
my_proc;
RETURN -003;
END my_func;

PROCEDURE my_proc IS
BEGIN
DBMS_OUTPUT.PUT_LINE('22');
END my_proc;

BEGIN -- main
DBMS_OUTPUT.PUT_LINE(my_func);
END;

-- IT WILL WORK FOR EVERY OCCURRENCE --

how the indexes are stored in the Oracle Database?

2272

---

What is the difference between Delete, Truncate and Drop in Oracle?

1131

---

What is a dynamic performance view in oracle?

997

---

What is SQL Tuning Advisor in Oracle?

1185

---

What is recycle bin in Oracle?

1153

---

Explain the importance of .pll extension in oracle?

1013

---

Query to retrieve record for a many to many relationship ?

2522

---

Explain oracle instance.

1185

---

How to drop an index?

966

---

How to retrieve data from an cursor to a record?

1108

---

What is where clause in oracle?

1032

---

Is oracle a language?

953

---

Explain the use of inctype option in exp command.

1034

---

What are the different editions of oracle?

1110

---

How do we create privileges in oracle?

1050

---