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
Explain about normal forms?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Who are naive users?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
How would you design a database for an online site, which would average a million hits a day?
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?
Explain what a database is?
How to customize error conditions.
What is an application role and explain a scenario when you would use one?
Explain the cube operator?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
How to generate OIDS
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?