Answer / guest

Well cursors help us to do an operation on a set of data
that we retreive by commands such as Select columns from
table. For example : If we have duplicate records in a table
we can remove it by declaring a cursor which would check the
records during retreival one by one and remove rows which
have duplicate values.

Answer / mohsin mohammed abdul

Cursors are the private memory area in the SGA. they store
the result set of a query. And they are used to fetch
multiple rows from the tables in the pl/sql block

Answer / kuttikrishnan kodoth

if we ant to retrive data from a database table having
duplicate entries which violates primarykey rule
we can handle this case using cursor, it by declaring a
cursor which would check the
records during retreival one by one and remove rows which
have duplicate values. there are many types of cursors to
fetch data in diffrent order like fetch first,fetch
last ,fetct prior,fetch next,fetch abslute n,fetch relative
n

Answer / sathish kumar.t

Cursors is one of the data object which is used to access
and manipulate the datas in the result set.

Answer / srinivas

Cursors are logical areas created on physical areas, i.e.,
tables to find a particular nth record.

Answer / vijay dev saxena

Basically cursor in an active dataset depends on query.
it is good to handling set of data.

Answer / venkat.bolla

Cursors allow you to take a set of data and process record
by record

Answer / mian ghous

broadly speaking ,,cursor can perfomr operaions on database
much like functions except returning a value i think

What is sql injection? How to protect against sql injection attack?

0 Answers  

How to find out what is the default collation in a database?

0 Answers  

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

How do I start sql server 2017?

0 Answers  

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

0 Answers   ADP, iSoft,

how can i view structure of table in sql server? tell me that query.

10 Answers  

Explain insert into select statement?

0 Answers  

What is normalization? Explain its different types?

0 Answers   GE, Maveric,

What is primary key and example?

0 Answers  

What is sql stored procedure?

0 Answers  

Which index created when Create Index on table(col), Why

2 Answers   CGI,

What is extended stored procedures?

0 Answers