Cheat Sheet

Oracle PL/SQL For Dummies Cheat Sheet

From Oracle PL / SQL For Dummies

By Michael Rosenblum, Paul Dorsey

Need to get up to speed on PL/SQL programming? To effectively use the PL/SQL programming language in the Oracle database environment, take a look at some PL/SQL models for using fundamental syntax and writing code.

Oracle PL/SQL Syntax Examples

After all the parts are in place and you’ve established the Oracle environment, you can start working with PL/SQL. Study this chart, which shows some basic PL/SQL syntax you need to know to control what statements execute next:


Oracle PL/SQL Code Samples

When programming PL/SQL, you want to structure the code so that it does what it is supposed to and, if changes are necessary, you can easily see where they’re needed. After all, your goal is well-written code that performs in a reasonable time frame and is bug-free whenever possible. Check out these models of PL/SQL code: