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
how can develope the po variance and po summary report? with tables mandatory columns and query please?
What are do's and dont's of Interface?
Explain what are the tables of auto invoice?
How many schemas we have? how many you have used?
tell me the scenarios of the independent in reports
What are the different components of soa suite?
What do you understand by soa and what are the benefits of using this architecture?
Are you familiar with internet architecture of oracle apps 11i?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
q)what are the validations in sql*loader
tell me the scenarios of the independent in reports
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
What do you understand by a set of books?
How to move the one file from one instance to another instance? And your scripts also?
What do you understand by soa?