What are cursors? Explain different types of cursors?
Answer Posted / daudkhan
A point to context area which has infromation for Oracle to
process SQL statements.
Cursors allow to fetch rows returned by a select statement.
Implicit cursor: Automatically declared
Explicit cursor: defined by programmer
| Is This Answer Correct ? | 14 Yes | 4 No |
Post New Answer View All Answers
Who are naive users?
Why does this query return 0?
What is normalization? Explain different levels of normalization?
State the acid rules?
Explain about query and reporting.
What is DB Development software?
Explain about the hierarchical model of the database?
What are the main phases of database development?
Explain about a primary key?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
What are data modelling techniques?
How to replace not in with not exist?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What is the database development process?
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?