Basic Oracle Concepts and Programming Question:
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.
► 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.
Previous Question | Next Question |
How To Pass a Cursor Variable to a Procedure? | What Is the Simplest Tool to Run Commands on Oracle Servers? |