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 are the differences between date and timestamp in oracle?
How to select an oracle system id (sid)?
What is the quickest way to export a table to a flat file?
How to rename an index?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to use "startup" command to start default instance?
How to display row numbers with the records?
Why is oracle so popular?
Explain the use of rows option in exp command.
what is the use of system.effective.date variable in oracle?
Difference between hot backup vs. Cold backup?
What is parameterized cursor in oracle?
How to define a variable of a specific record type?
How to use subqueries with the in operator using oracle?