Answer Posted / raj dhar

Function :- Function always return one value.
Procedure :- Procedure may or may not be return value.

Function :- Function always required " RETURN " key word.
Procedure :- Procedure doesn't require " RETURN" key word.

Function :- Function we use parameter IN.
Procedure :- Procedure we use parameter IN,OUT,INOUT.

etc.

What is query image?

922

---

How to check the oracle tns settings?

990

---

How to define a procedure inside another procedure?

961

---

What is materialized view in Oracle?

1042

---

What are set operators?

1029

---

How to convert a date to char in oracle? Give one example.

1001

---

if you ctreate table identity

2313

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1955

---

How to get the Installed Oracle Version Information ?

1073

---

What does sharding mean?

946

---

What is set verify off in oracle?

1030

---

How to define a data field as not null?

1060

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2173

---

How to compare dates in oracle sql?

1041

---

What is Virtual Private Database in Oracle?

1015

---