what is the cursor and use of cursor in pl/sql ?

Answers were Sorted based on User's Feedback



what is the cursor and use of cursor in pl/sql ?..

Answer / prince pradeep

cursor is a handle or a pointer to a context area;
(context area is a memory area where sql statements are processed)
cursors are used to retrieve multiple records from data base

Is This Answer Correct ?    5 Yes 0 No

what is the cursor and use of cursor in pl/sql ?..

Answer / sanjeev

cursor is private memori location, this is storing the data local mechin this will excut the program this cursor automatically deleted

Is This Answer Correct ?    3 Yes 0 No

what is the cursor and use of cursor in pl/sql ?..

Answer / udaykumar

cursor is a private workspace memory,it does'nt stored in
the database.It is a buffer.

Is This Answer Correct ?    1 Yes 0 No

what is the cursor and use of cursor in pl/sql ?..

Answer / kesav

A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are analytical functions in sql?

0 Answers  


Types of backups ?

3 Answers   TCS,


how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  


How can you save or place your msg in a table?

0 Answers  


Is grant a ddl statement?

0 Answers  






What is pl sql quora?

0 Answers  


i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,


What is Temp Table and type of temp table?

1 Answers   HP, SLK,


What is schema in sql example?

0 Answers  


I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,


what is heap table? : Sql dba

0 Answers  


Why do we go for stored procedures?

0 Answers  


Categories