Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mohan
Cursor: Cursor is a pointer which is used to fetch one by one record from active set into plsql block.
Types: There are two types of cursors we have in plsql.
they are,
1. Implicit Cursors
2. Explicit cursors
1.Implicit cursors: when ever we perform sql operations then automatically implicit cursors will come into the picture. no need to declare,open,fetch and close implicit cursors.
2.Explicit cursors: These are user defined cursors. we have to declare,open,fetch and close these cursors.
Cursor Attributes:
1.%found
2.%notfound
3.%isopen
4.%rowcount
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to connect to the server with user account: sys?
How would you go about verifying the network name that the local_listener is currently using?
What are nested tables?
What is null value in oracle?
Why is oracle used?
What privilege is needed for a user to delete rows from tables in another schema?
What is redo log?
What are the numeric comparison operations?
How to convert numbers to characters in oracle?
What is a parameter file in oracle?
Explain the different normalization forms?
How to establish administrator authentication to the server?
What is Redo Log Buffer in Oracle?
Explain parameter file in oracle.
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
