what is the cursor and use of cursor in pl/sql ?

Answer Posted / kesav

A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is auto increment?

580


Show how functions and procedures are called in a pl/sql block.

586


what is rdbms? : Sql dba

575


The in operator may be used if you know the exact value you want to return for at least one of the columns.

554


how to check myisam tables for errors? : Sql dba

597






Is delete faster than truncate?

543


what are the authentication modes in sql server? : Sql dba

528


Explain clause in sql?

559


Can we use join in subquery?

565


What is error ora-01000: maximum open cursors exceeded

598


What is procedure and function?

513


What is the use of prepared statement?

536


Write a sql select query that only returns each name only once from a table?

565


What is the maximum number of rows in sql table?

543


What are the types of sql commands?

548