Answer Posted / t.r.sekhar
cursor is a temporary buffer used to hold the transactional
data for the manipulation purpose.
data will not permanently stored in database.
it is not reusable.
syntax:
cursor <cursor name> is <select stmt);
we have two types of cursors are there.
1.implicit cursors-automatically created whenever dml
statements are executed.
2.explicit cursors-created by user
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Write an sql query to select all records from the table?
How is a PL/SQL code compiled?
what is the syntax for using sql_variant_property? : Transact sql
What is autocommit sql?
What are user defined functions?
What is difference between left and right outer join?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
explain advantages of myisam over innodb? : Sql dba
Can we use loop in sql?
Whis is not false in primary key?
Why is %isopen always false for an implicit cursor?
What is pl sql block in dbms?
How can we find duplicate records in a table?
Is sql a scripting language?
What is right join sql?