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

How do you update f as m and m as f from the below table testtable?

0 Answers  


Can we use having without group by in sql?

0 Answers  


how to get the third quarter of employee details from emp?

2 Answers   CompuTech,


What are aggregate and scalar functions?

0 Answers  


How to create your own reports in sql developer?

0 Answers  






How to write html code in pl sql?

0 Answers  


What is a natural join?

0 Answers  


What are the different types of database management systems?

0 Answers  


how to get @@error and @@rowcount at the same time? : Sql dba

0 Answers  


Explain cursor types?

0 Answers  


Give an example of Full Outer Join?

1 Answers   IBM,


What is package in pl sql with an examples?

0 Answers  


Categories