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
Can you drop an index associated with a unique or primary key constraint?
How do I limit the number of rows returned by an oracle query after ordering?
How to delete multiple rows from a table in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to update values on multiple rows in oracle?
How do I spool in oracle?
How many types of database triggers exist?
What happens in oracle commit?
What is a cognitive schema?
Define oracle database
How does Oracle guarantee data integrity of data changes?
what is meant by magic query
What is the order of defining local variables and sub procedures/functions?
What is format trigger?