Types of cursors and explanation each of them ?
Answer Posted / sohail
Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
How many types of privileges are available in sql?
How is a PL/SQL code compiled?
What types of commands can be executed in sql*plus?
What is dba in sql? : SQL DBA
what is the difference between clustered and non clustered index in sql? : Sql dba
Is sql low level language?
what is a database lock ? : Sql dba
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
How many types of triggers exist in pl/sql?
What is the use of index in hive?
How to select all records from the table?
What is the purpose of primary key?
Is sql between inclusive?
Is merge a dml statement?
Is pl sql and postgresql same?