difference between imlicit cursor and explicit cursor ?
Answer Posted / vipin kumar ( m.c.a)
1. Implicit cursor:- means predefine cursor. Its attributes
starting with the sign % like that %ROWCOUNT, %ISOPEN etc.
2. Explicit cursor:- means created by the user or
programmer. Its attributes starting with the cursor name
then % sign lick that cursorname%ROWCOUNT, cursorname%ISOPEN
etc.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In which language oracle has been developed?
What is a proxy class?
How to create a new view in oracle?
How to define an anonymous block?
Hi Can any one tell me what are the API's used in requisition import.
How do I start tns listener?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is MTTR advisor in Oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to store only time; not date and time?
What are the extensions used by oracle reports?
What is merge statement used for?
Will you be able to store pictures in the database?explain.
What is the Tune Query
does the query needs a hint to access a materialized view?