what is difference between procedure and function
Answer Posted / venky
Function can be use in SQL queries
Procedure can't be used in SQL queries
Function call by an Expression
Procedure call by Statement
The Main diff is DML
Through procedures we can insert,update,delete data from
Table
Through Functions we can't
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Is soa a part of oracle fusion middleware?
Can you define an erp system?
What do you understand by a set of books?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Can you differentiate between mediator and osb?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What are the Standard Reports and Forms in HRMS?
what is global tempory table?
Can you explain the difference between architecture followed in 10g & 11g?
What are file in oracle.
What do you understand by soa and what are the benefits of using this architecture?
How to move the one file from one instance to another instance? And your scripts also?
Are you familiar with internet architecture of oracle apps 11i?
Do you know what are user profiles in apps. Any examples you can give?
tell me the scenarios of the independent in reports