Interested to Buy Any Domain ? << Click Here >> for more details...
what diffrence between function and procedure?
- 4 Answers
- 8077 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 do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How would you change old and new values in an insert, delete and update triggers?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
Explain the difference between sql and oracle?
What is a user role in oracle?
Can we protect our pl/sql source code?
Is it possible to disable the parameter from while running the report ?
How to insert a new row into a table in oracle?
What would you use to improve performance on an insert statement that places millions of rows into that table?
definition of cluster and non-clustered index?
What is indexing, and how does it improve performance?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Oracle General 
