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
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.