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
What is the quickest way to fetch the data from a table?
What do you mean by cdb and pdb in oracle 12c?
How to load a large xml file?
How to retrieve data from an cursor to a record?
How to export data to a csv file?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to define a record variable to store a table row?
What are the logical operations?
How do I limit the number of oracle database connections generated by weblogic server?
Can objects of the same schema reside in different tablespace?
What is backup in Oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How to install oracle database 10g xe?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Is there a function to split a string in plsql?