Answer Posted / 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 |
Post New Answer View All Answers
How do I spool to a csv formatted file using sqlplus?
How to write text literals in oracle?
What is concurrency in oracle?
What are the various types of snapshots ?
candidate key is subset of super key but not vice-verse explain
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is tns name?
What is oracle open database communication (odbc)?
What is the difference between hot backup and cold backup in oracle?
Respected sir, Please send me technical questions related to oracle apps..
What is java oracle used for?
What are the different types of record groups in oracle? Explain each of them
Can you drop an index associated with a unique or primary key constraint?
Explain about integrity constraint?