Answer / preethi

Cursors are work areas used for internal processing in
order toexecute an SQL statement.

Two tpes of Cursors
Implicit Cursors and Explicit Cursors.
Explicit Cursors can be further classifed into three
Named Cursors,Parameterized Cursors and Ref Cursors

Answer / ramesh

Implicit Cursors --Occurs on behalf of every sql statement
Explicit Cursors --Named Cursors used in Plsql
Paramaeteried Cursors --Pass Paramters to a Named Cursor


Cheers,
Ramesh

Answer / 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

Answer / banoj swain

cursor is nothing but a pointer pointing to the context area assigned by oracle for processing of sql statement.pl/sql programs control context area by using cursor.
types:1)static 2)dynamic or ref cursor
again static is of two types
1)explicit 2)implicit
dynamic of two types:
1)strong 2)weak

Answer / siva

cursor is nothing but buffer area it is process by multiple records and also record by record process.
they are two types
1.implicit cursor:- it is returned only single value.(it is created by default system )
2.explicit cursor:- it is returned multiple values.( it is created by user).

Answer / vishnuvardhan reddy

in db2 there are two types of cursors
1.scrolable cursor
2.non scrolable cursor

scrolable cursor:
scrolable cursor can be moved in sequential
forword (or)backword direction in the resultant table.

Non scrolable cursor:
simplest cursor is the non scrolable cursor
it is always moved in a sequential direction.

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? <?xml version="1.0"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description> two of our famous Belgian Waffles with plenty of real maple syrup </description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$7.95</price> <description> light Belgian waffles covered with strawberries and whipped cream </description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$8.95</price> <description> light Belgian waffles covered with an assortment of fresh berries and whipped cream </description> <calories>900</calories> </food> <food> <name>French Toast</name> <price>$4.50</price> <description> thick slices made from our homemade sourdough bread </description> <calories>600</calories> </food> <food> <name>Homestyle Breakfast</name> <price>$6.95</price> <description> two eggs, bacon or sausage, toast, and our ever-popular hash browns </description> <calories>950</calories> </food> </breakfast_menu>

0 Answers  

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

What are defaults? Is there a column to which a default can't be bound?

2 Answers  

Explain about query and reporting.

0 Answers  

What are the 18 schemas?

0 Answers  

Who are naive users?

0 Answers  

What is the system function to get the current user's user id?

4 Answers  

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

0 Answers  

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

0 Answers   TCS,

What is a self join? Explain it with an example?

16 Answers   TCS,

what is Normalization?

6 Answers   TCS,

What is bit datatype and what's the information that can be stored inside a bit column?

2 Answers