What are main difference between Stored Procedure and
Functions.
Answer Posted / guru
stored procedure : It is Pre Compiled Code(PCode) it is stored
in Database. we can reuse without compile.
Function: It need compile whenever it will run.
Is This Answer Correct ? | 15 Yes | 4 No |
Post New Answer View All Answers
How to start instance with a minimal initialization parameter file?
How to test null values?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What are the extensions used by oracle reports?
What are the roles of dba?
How translate command is different from replace?
What are the ways tablespaces can be managed and how do they differ?
In oracle there is column command, how will you explain that?
What is oracle thin client?
How to Truncate Table in Oracle
What are group functions in oracle?
What is a sub query and what are the different types of subqueries?
What are the restrictions in a oracle read only transaction?
How to connect to oracle using service name instead of sid?
How to see free space of each tablespace?