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 --

what is dynamic SGA and static SGA

4325

---

State all possible different index configurations a table can possibly have?

945

---

What is define in oracle?

998

---

In oracle there is column command, how will you explain that?

964

---

What is the dynamic sql in oracle?

1006

---

What is meant by an index?

1054

---

How will you differentiate between varchar & varchar2?

990

---

What is the difference between postgresql and oracle?

977

---

What are the attributes of the cursor?

931

---

Which is better Oracle or MS SQL? Why?

6260

---

Explain the use of indexes option in exp command.

1063

---

How to define an oracle cursor variable?

972

---

How to connect to the server with user account: sys?

968

---

What is a schema in oracle?

965

---

What is oracle and what are its different editions?

1007

---