Skip to Main Content

Cursor Variables

Resources

  • #SELECTION#
    #ICON_HTML#

    Weak Ref Cursor Types: Do I ever need to declare my own? No!

    Need to declare a cursor variable for dynamic SQL? Then you need to use a "weak" REF CURSOR type. But you don't have to declare your own; PL/SQL provides one for you, and you'll never need more than one!
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Working with Cursor Variables

    Oracle Magazine article on cursor variables by Steven Feuerstein
    #MISC#
    #ACTIONS#
  • #SELECTION#
    #ICON_HTML#

    Using Ref Cursors To Return Recordsets

    Since Oracle 7.3 the REF CURSOR type has been available to allow recordsets to be returned from stored procedures and functions. Oracle 9i introduced the predefined SYS_REFCURSOR type, meaning we no longer have to define our own REF CURSOR types.
    #MISC#
    #ACTIONS#

Featured Speakers

Workshop Info

Session Has Completed - 02 April 2019
1 Hour
Webinar
English
Oracle PL/SQL

Hidden Translations

Join
Share
Register
English
Unregister
Outline
Objectives
Resources
02 April 2019
Session Has Completed - 02 April 2019
You Are A Speaker/Panelist
1 Hour
Pending
Prerequisites
Waitlisted
Rejected
Question And Answer
Register And Join
Add To Calendar
Registration Status
Series Name
Session Time
Log In To Register
You Are Registered. You Will Be Able To Join The Session 15 Minutes Before It Starts.
You Are Signed Up for the Lab
Sign Up for Lab
Remove Lab Sign Up