What are cursors? Explain different types of cursors?

Answer Posted / daudkhan

A point to context area which has infromation for Oracle to
process SQL statements.
Cursors allow to fetch rows returned by a select statement.

Implicit cursor: Automatically declared
Explicit cursor: defined by programmer

Is This Answer Correct ?    14 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1585


Explain about normal forms?

599


How to use online Backups?

1725


Explain what a database is?

613


Explain the rollup operator?

612






You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

547


Explain about network model?

585


Explain about the hierarchical model of the database?

580


Explain about the relational database?

608


What is an application role and explain a scenario when you would use one?

560


What are the key features of dbms?

565


How to use timestamp datatypes

1576


When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

1785


Explain about relational operator join?

611


Who are end users in dbms?

548