Answer Posted / suresh kumar somayajula
Cursor : It's a private SQL worksheet area where we can
execute SQL commands and processing information.
The purpose of the Cursor is, PL/SQL execution block will
process only one records means it will return only one
records.If we want to retrieve or process more number of
records we use the "Cursors".
These are of two types.
1. Implicit Cursor 2. Explicit cursors.
Thank you,
Suresh
| Is This Answer Correct ? | 30 Yes | 1 No |
Post New Answer View All Answers
what is the difference between clustered and non clustered index in sql? : Sql dba
Is it possible to create the following trigger: before or after update trigger for each row?
What are local and global Indexes and where they are useful.
What is auto increment in sql?
What is the maximum database size for sql express?
What is full form of rtm?
What is t sql in sql server?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
what is table? : Sql dba
what is an alias command? : Sql dba
How do I add a database to sql?
Which join is default?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
what is sql? : Sql dba
Can we use ddl statements in stored procedure sql server?