what diffrence between function and procedure?
- 4 Answers
- 7084 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / manu sankar
Functions can be called inside a sql but procedures cannot
| Is This Answer Correct ? | 1 Yes | 0 No |
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
| Is This Answer Correct ? | 1 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
How to calculate date and time differences in oracle?
How do I start tns listener?
Is there an oracle sql query that aggregates multiple rows into one row?
How to convert csv to table in oracle?
What is different types of joins?
Explain oracle’s server parameter file.
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is Network Database link ?
Where do you use decode and case statements?
How to call a stored function with parameters?
What is an oracle data file?
Oracle General 
