Interested to Buy Any Domain ? << Click Here >> for more details...
what diffrence between function and procedure?
- 4 Answers
- 7907 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 can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
What is a partition in oracle?
What are data pump export and import modes?
Can we save images in a database and if yes, how?
What is the use of Control File ?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How do we display rows from the table without duplicates?
What do you know about normalization? Explain in detail?
Explain the truncate in oracle?
What to do if the startbd.bat failed to start the xe instance?
what is shell?
does Oracle has only one table space?
Oracle General 
