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 |
How can a process be deployed in soa?
Can you explain the difference between architecture followed in 10g & 11g?
what is repeting frame?
what are the match approvals in PO?
What is oracle soa suite and what are its different components?
What is workflow?Explain with a example?
35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?
In one flat file i got headers and lines data how you can write control file now ?
How do you register report in oracle apps?
what is meant by lexical parameter
Do you know what are user profiles in apps. Any examples you can give?
what is instead of trigger. what is the use of that?