Dan Hotka’s PL/SQL Tips & Techniques

On-Demand Webinar

In part one of this two-part series, Oracle ACE Director, Dan Hotka and Solutions Consultant Director, Scott Walz share the fundamentals of PL/SQL with helpful techniques explaining variable types to tips and techniques on how to code PL/SQL.

Then watch part two of the series, where they continue to build on that knowledge and share even more expertise on PL/SQL procedures, functions and packages.

Watch the on-demand webinar to learn about:

  • PL/SQL variable types and naming convention
  • How to code PL/SQL
  • When to use IF-THEN-ELSE or CASE
  • Profiling and debugging PL/SQL
  • Procedures, functions and packages
  • Tips on PL/SQL compiling options
  • Performance tuning


Dan Hotka is a training Specialist and an Oracle ACE Director who has over 36 years in the computer industry, and over 30 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well-published with12 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.


Scott Walz has more than 20 years of experience in the area of database development and currently serves as the Director of Software Consultants for Embarcadero Technologies. Prior to joining Embarcadero 12 years ago, Scott served as a development lead for Louisville Gas and Electric. He holds a bachelor's degree in computer information systems from Western Kentucky University.