Interested to Buy Any Domain ? << Click Here >> for more details...
what diffrence between function and procedure?
- 4 Answers
- 7735 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 |
What is an oracle tablespace?
query optmization techniques and quwry analyser+projects+ppts
How do I spool to a csv formatted file using sqlplus?
What are the components of physical database structure in the Oracle database?
What is a snapshot in oracle database?
What is a trigger and what are its types?
How to delete a column in an existing table in oracle?
How to use select statement to count the number of rows in oracle?
What are the numeric comparison operations?
What are group functions in oracle?
Can a field be used in a report without it appearing in any data group ?
Explain overloading. Can functions be overloaded?
Oracle General 
