CHAPTER 2PL/SQL Basics

You can take many approaches when explaining the basics of any programming language. In the context of a workbook, the briefest is the best. You find more complete treatment in Oracle Database 11g PL/SQL Programming. Here we’ll focus on the bare bones that you need to code.

You’ll learn how to organize your program units, where to put the pieces that make your programs work, what you should and shouldn’t do, and what to avoid at all costs. While opinions vary on many aspects of programming, the tips provided here should serve you well, because they’ve served us well.

You should be able to work through this chapter sequentially or skip to where you need to go for quick insight into a principle, skill, or technique. Here’s ...

Get Oracle Database 11g PL/SQL Programming Workbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.