Answer / deepu

functions and procedures are both pl/sql programs.
procedures performs a specific task,it takes parameters and
performs the actions.
functions are same as procedures except they wil return a
value.

Answer / manu sankar

Functions can be called inside a sql but procedures cannot

Answer / pr@$@d

Hi Raj ,

Nice answer,

We can use OUT,INOUT also in function but it is not
suggested by Oracle.

Thanks,
-Pr@$@d.
prasadreddi@ymail.com

Answer / 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.

State some uses of redo log files?

0 Answers  

---

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,

---

How to use "if" statements on multiple conditions?

0 Answers  

---

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,

---

How to export data to a csv file?

0 Answers  

---

write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers   British Telecom BT,

---

What are the uses of Rollback Segment ?

2 Answers  

---

what is the difference between dbms and rdbms?

3 Answers   Oracle,

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

1 Answers  

---

How can we create the complete backup of data in the oracle.

0 Answers   IPEC, Satyam, SunTec,

---

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

0 Answers   MCN Solutions,

---

what is exact difference between drop and truncate table.

3 Answers  

---