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

Answer / sanjeev

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

Answer / udaykumar

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

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.

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

What are sql built in functions?

0 Answers  

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,

---

explain what is mysql? : Sql dba

0 Answers  

---

Which join is default?

0 Answers  

---

What are the different types of triggers?

0 Answers  

---

what is try_catch block in procedure

0 Answers  

---

What is posting?

0 Answers  

---

how to create object in plsql

3 Answers   Microsoft,

---

How to write html code in pl sql?

0 Answers  

---