Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


why use cursors?

Answers were Sorted based on User's Feedback



why use cursors?..

Answer / suresh kumar somayajula

Cursor : It's a private SQL worksheet area where we can
execute SQL commands and processing information.
The purpose of the Cursor is, PL/SQL execution block will
process only one records means it will return only one
records.If we want to retrieve or process more number of
records we use the "Cursors".
These are of two types.
1. Implicit Cursor 2. Explicit cursors.

Thank you,
Suresh

Is This Answer Correct ?    30 Yes 1 No

why use cursors?..

Answer / aravind

Cursor is used to process multiple rows using pl/sql.

Is This Answer Correct ?    16 Yes 4 No

why use cursors?..

Answer / sri

mainly cursor is used to to process the multiple records
from database

Is This Answer Correct ?    2 Yes 0 No

why use cursors?..

Answer / selvaraj v , anna university c

Cursors allow row-by-row processing of the result sets.
Retrieve more than one rows from table or database to use
Curosrs.

Is This Answer Correct ?    2 Yes 0 No

why use cursors?..

Answer / chandu

to perform multiple rows accessing.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer



More SQL PLSQL Interview Questions

what are the types of join and explain each? : Sql dba

0 Answers  


What is a join?Explain the different types of joins?

6 Answers   Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,


1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  


What are the operators used in select statements?

0 Answers  


SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,






Does view store data in sql?

0 Answers  


What is primary key in db?

0 Answers  


write a query to find 4th max salary

7 Answers  


how to decrement dates by 1 in mysql? : Sql dba

0 Answers  


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

0 Answers  


What is Highwatermark?

3 Answers   Thermotech,


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  






Categories