Types of cursors and explanation each of them ?

Answers were Sorted based on User's Feedback



Types of cursors and explanation each of them ?..

Answer / sohail

Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.

Is This Answer Correct ?    8 Yes 4 No

Types of cursors and explanation each of them ?..

Answer / anusha

Cursor is a private work area .there are
three types if cursors
1.implicit cursor: implicit cursors is create,open and
closed by system automatically.
2.explicit cursor: explicitly user can create,open and close
cursors.
3. ref cursor: Reference cursor is a cursor dynamically (at
Run time) we can pass the column names or table names.

Is This Answer Correct ?    1 Yes 0 No

Types of cursors and explanation each of them ?..

Answer / giri

Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.sql%found,sql%notfound,sql%is open,sql%count these are the implicit cursor attributes.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.%found,%notfound,%is open,%count these are the explicit cursor attributes.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.

Is This Answer Correct ?    1 Yes 0 No

Types of cursors and explanation each of them ?..

Answer / aditya

Ref cursor have two types strong ref cursor and weak ref cursor.

declaring a ref cursor and using it for multiple select statements is a weak cursor.

using a ref cursor as an out parameter to get a result set is a strong ref cursor.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is the main difference between join and subqurey?

3 Answers   Oracle,


What is form and report?

0 Answers  


What is raid? How does it help storage of databases?

0 Answers  


What type of database is sql?

0 Answers  


Can you have more than one trigger on a table?

0 Answers  






Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,


When would you denormalize?

8 Answers   MBT, Microsoft, MMU,


how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,


Is sql a backend language?

0 Answers  


can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,


What is nvarchar in sql?

0 Answers  


What are crud methods?

0 Answers  


Categories