Interested to Buy Any Domain ? << Click Here >> for more details...
what diffrence between function and procedure?
- 4 Answers
- 7941 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 |
Is java required for oracle client?
How many types of synonyms in Oracle?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
How to run create database statement?
What is a recycle bin in oracle?
how to get the no employee in each department including the dept which has 0 employee
How to list all indexes in your schema?
How many types of tables are there in oracle?
what are stored procedures?
How to get the Installed Oracle Version Information ?
Explain the relationship among Database, Tablespace and Data file?
What is a server parameter file in oracle?
Oracle General 
