Basic Oracle Concepts and Programming Question:

Why Cursor Variables Are Easier to Use than Cursors?

Tweet Share WhatsApp

Answer:

Cursor variables are easier to use than cursors because:

► Cursor variables are easier to define. No need to give a specific query statement.
► Cursor variables are easier to open. You can specify the query dynamically at the time of open.
► Cursor variables can be passed into procedures or functions.


Download Oracle Database PDF Read All 430 Oracle Database Questions
Previous QuestionNext Question
How To Pass a Cursor Variable to a Procedure?What Is the Simplest Tool to Run Commands on Oracle Servers?