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
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Explain oracle left join with an example?
What is a oracle database?
What is a subquery?
Explain a data segment?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is index in Oracle?
Why do we use bulk collect in oracle?
What is oracle thin client?
various types of hints and their usage
What is a nested table?
 What are the oracle DML commands possible through an update strategy?
Differentiate between post-database commit and post-form commit?
Can you tell me how to add new column in existing views?how?How is possible?
Explain enable novalidate constraint.