Basic Oracle Concepts and Programming Question:
Download Questions PDF

Why Cursor Variables Are Easier to Use than Cursors?

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 Interview Questions And Answers PDF

Previous QuestionNext Question
How To Pass a Cursor Variable to a Procedure?What Is the Simplest Tool to Run Commands on Oracle Servers?