What are cursors?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 4 Yes | 0 No |
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
Is This Answer Correct ? | 4 Yes | 2 No |
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
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sathish kumar.t
Cursors is one of the data object which is used to access
and manipulate the datas in the result set.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / srinivas
Cursors are logical areas created on physical areas, i.e.,
tables to find a particular nth record.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vijay dev saxena
Basically cursor in an active dataset depends on query.
it is good to handling set of data.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / venkat.bolla
Cursors allow you to take a set of data and process record
by record
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mian ghous
broadly speaking ,,cursor can perfomr operaions on database
much like functions except returning a value i think
Is This Answer Correct ? | 1 Yes | 2 No |
Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY
What are subqueries in sql server? Explain its properties.
Explain transaction server implicit?
what is the use of database index(apart from the last searching of records) and what is the use of composite key?
Can a rule be bound to any column of any data type?
What are the differences between stored procedure and view in sql server?
Where is localdb stored?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
how many type of indexing in database?
What is the difference between row_number and dense_rank?
How to get the count of distinct records. Please give me the query?
What is a periodical index?