difference b/w procedures&functions

Answer Posted / raghu

procedure may or may not return a value.
function return a value
procedure will be storeed in db as a compiled object
but funtion will be stored as text what we written

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain the difference between architecture followed in 10g & 11g?

659


tell me the scenarios of the independent in reports

2051


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

1888


In sequence i want to 11 and 15th values how we will write?

1573


how do you describe O2C along with tables

2309






tell my any difficult situtation you solved in your experience in your company?

1866


Plz anybody send me Technical specification for AP Interface

2013


q)what are the validations in sql*loader

1742


How to move the one file from one instance to another instance? And your scripts also?

615


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2092


how can i print random rows in plsql table

1940


What is a value set? List its various types.

650


In hierarchical structure of a database? we have write query from where we should start?

1708


How do you register report in oracle apps?

632


Explain what are the tables of auto invoice?

648