Why Cursor Variables Are Easier to Use than Cursors

Q

Why Cursor Variables Are Easier to Use than Cursors? - Oracle DBA FAQ - Working with Cursors in PL/SQL

✍: 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.

2007-04-28, 4629👍, 0💬