what is the difference between procedure and function
Answers were Sorted based on User's Feedback
Answer / mry
procedure is for specific task and can return one or more
values to the caller
where as function is used for computing a value and it must
return a single value to the caller
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / tamil selvan.s
Main diff between procedure and function is
function can be used in select statement but
we cannot use procedure
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ramesh babu maldakal
1 Function returns the values but not procedure
2 We can call the functions in select statement but not
procedures
3 In procedures we can perform the DML operations but not
in Functions
Is This Answer Correct ? | 2 Yes | 1 No |
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
What are the tables in GL?
what is fiscalcalendar?
in one report using two layout models.if yes how to do
What is a flexfield? List out its types.
Can we customize a form with out template.fmb
Which one Module is Biggest Module in oracle apps?
in procedure how to return a value
How to call oracle database stored procedure from form in form coding ?
what are the steps to develop a new report?
What is ment by Global Templates in Oracle.
What is menu.