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

Which are sql * plus commands?

0 Answers  


Can we join tables without foreign key?

0 Answers  


What does select top 1 do in sql?

0 Answers  


What is the difference between explicit and implicit cursors in oracle?

0 Answers  


What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,






What do you mean by rowid?

0 Answers  


Is left join inner or outer?

0 Answers  


When should I use nosql database?

0 Answers  


What is not equal in sql?

0 Answers  


Will truncate release space?

0 Answers  


What are the types of sql commands?

0 Answers  


Which is the best place to learn hadoop?

1 Answers  


Categories