Find tips for creating efficient PL/SQL code
If you know a bit about SQL, this book will make PL/SQL programming painless!
The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more.
Discover how to
- Write efficient, easy-to-maintain code
- Test and debug PL/SQL routines
- Integrate SQL and PL/SQL
- Apply PL/SQL best practices
- Use new features introduced in Oracle 9i and 10g
PL/SQL (pronounced P-L-S-Q-L or P-L-see-quel) is a programming language that was created by Oracle as a procedural language fully integrated with SQL, to be used in working with Oracle databases. Anyone contemplating working in the Oracle environment needs to know PL/SQL.
In many ways, PL/SQL is a standard procedural programming language. It has functions, procedures, variable declarations, loops, recursion, and so on. If you’re familiar with the programming language Ada, you’ll find it’s similar to PL/SQL. If you’ve used any standard programming language, such as C or Pascal, you’ll find yourself quite at home with PL/SQL. If you’re an objectoriented (OO) programmer who is used to languages like C++ or Java, you can’t use your OO techniques as easily in PL/SQL, but all your procedural experience will transfer quite easily.
What makes PL/SQL special is that it is fully integrated with SQL. This makes it a wonderful language to use when programming applications that need to interact with an Oracle database.