Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is memory advisor in Oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is an oracle?
What is PL/SQL ?
How to change program global area (pga) in oracle?
Hi Can any one tell me what are the API's used in requisition import.
Is oracle the best database?
How to delete a column in an existing table?
How to insert a new row into a table in oracle?
What is oracle rownum?
State and explain about oracle instance?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Why is oracle used?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is a cursor in oracle?
