Exploring Cursor Variables in PL/SQL
Cursor variables (variables declared based on a REF CURSOR type) offer some interesting advantages over "hard-coded" or explicit cursors (CURSOR my_cur IS ...), especially lots of flexibility and the ability to pass a cursor as a parameter or even the return value of a function.
Highlights
01:55 Introduction to cursor variables
02:55 Why use cursor variables?
05:36 Dev Gym use of cursor variables
08:03 Diving into cursor variable syntax and usage
15:15 Q&A: how best to log and propagate exceptions up the stack
23:05 Performance impact of using cursor variables
26:05 Using cursor variables to make dynamic SQL method 4 easier
33:00 Cursor variables and cursor expressions
37:45 More Q&A
39:24 Chris’s experience with cursor variables (before joining Oracle)
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
https://asktom.oracle.com/
Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit
On this page of the site you can watch the video online Exploring Cursor Variables in PL/SQL with a duration of hours minute second in good quality, which was uploaded by the user Oracle Developers 03 April 2019, share the link with friends and acquaintances, this video has already been watched 2,845 times on youtube and it was liked by 30 viewers. Enjoy your viewing!
