what diffrence between function and procedure?
- 4 Answers
- 8164 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 insert all statement in sql
what diffrence between function and procedure?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to select all columns of all rows from a table in oracle?
How to do clean up if create database failed?
What are the major difference between truncate and delete?
Can a View based on another View ?
What is an oracle user account?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
how to tune oracle sql queries pls tell me step by step. urgent pls
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
Oracle General 
