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 a stored procedure in sql with example?
What is data type in sql?
How to know the last executed procedure?
What is the use of sqlerrd 3?
How do I know if I have sql express or standard?
What is pragma in pl sql?
Can we call dml statement in function?
What is meant by <> in sql?
what are different types of collation sensitivity? : Sql dba
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is a pdo connection?
Is postgresql a server?
Explain how can you save or place your msg in a table?
Is left join and outer join same?
Explain the uses of a database trigger?