Cursor Variable Easier to Use than Cursor in Oracle

Q

Why Cursor Variables Are Easier to Use than Cursors in Oracle?

✍: FYIcenter.com

A

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.

 

Working with Cursors in Oracle PL/SQL

⇒⇒Oracle Database Tutorials

2016-10-17, 154👍, 0💬