Skip to Main Content

Explore Oracle PL/SQL

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

August 06, 2019

14:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Modularization Controversies!
It's no surprise that different developers have different attitudes and beliefs about how to best write code. In this session, we'll take a look at a few "controversies" as relates to writing program units in PL/SQL, including: procedures vs functions, functions and OUT parameters, schema-level subprograms vs packages, packages vs object types, multiple OUT parameters vs record type, use or avoid triggers....and whatever other Big Questions attendees bring to the session.

02:15 Review of controversies to discuss
04:00 Procedures vs functions, featuring Nat Dunn!
22:08 Functions and OUT parameters
28:22 Schema-level subprograms vs packaged
39:45 Packages vs object types
45:05 Multiple OUT parameters vs record

Your Experts

    Steven Feuerstein

    Steven Feuerstein   

    Steven Feuerstein is a Senior Advisor at Insum Solutions (, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). You will find an abundance of quizzes from Steven at the Dev Gym. Enjoy!