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 to write a left outer join with the where clause in oracle?
What is max rowid in oracle?
Why do we need integrity constraints in a database?
How to use "startup" command to start default instance?
What is oracle and what are its different editions?
How to define a variable of a specific record type?
what is the difference between substr and instr function in oracle?
Is postgres faster than oracle?
How to do paging with oracle?
How to rename an index in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Can we protect our pl/sql source code?
How to define a variable to match a table column data type?
What is query image?
What are the execution control statements in oracle?
