Oracle SQL Question:

What is is a cursor?

Tweet Share WhatsApp

Answer:

Oracle uses work area to execute SQL statements and store processing information PL/SQL construct called a cursor lets you name a work area and access its stored information A cursor is a mechanism used to fetch more than one row in a Pl/SQl block.

Cursor is a variable.
it is similar to a 2D array .
used for processing multiple rows.
used for storing data temporarily.

Download SQL Oracle PDF Read All 16 SQL Oracle Questions
Previous QuestionNext Question
Explain What is difference between SQL and SQL*PLUS?Explain What are various joins used while writing SUBQUERIES?