Skip to Main Content

Explore Oracle PL/SQL

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

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Header container

August 06

14:00 UTC   Start Times Around the World

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

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


Your Experts
Steven Feuerstein
Steven Feuerstein, Developer Advocate for PL/SQL    
Steven Feuerstein leads a team of Developer Advocate at Oracle Corporation, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). He's published over 1400 quizzes on PL/SQL at the Oracle Dev Gym.