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
Explain oracle apps architecture.
Do you know where we can check the status of po?
can we get profile values in report without using user exists is it possible how?
In hierarchical structure of a database? we have write query from where we should start?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What do you understand by soa?
What is oracle soa suite?
How can you achieve loose coupling in soa framework?
what is the differences between internal requisition and internal sales order?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
In oracle application how do you debug or trace errors?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
testing tools?
What do you understand by concurrent programs?
what are the balancing segments in AR?