Book description
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
Table of contents
- Title
- Contents
- Introduction
- Part I : Basic PL/SQL Concepts
- Part II : Getting Started with PL/SQL
- Part III : Standards and Structures
- Part IV : PL/SQL Data Manipulations
- Part V : Taking PL/SQL to the Next Level
-
Part VI : The Part of Tens
-
Chapter 15: Ten PL/SQL Tips
- Use SELECT INTO Correctly
- Don’t Assume Column Order in DML Statements
- Use the NOCOPY Command
- Be Careful of Function Calls That Impact Performance
- Beware of Implicit Commits
- Use Only One RETURN Statement per Function
- Save Debugging Time with WHEN OTHERS
- Know When to Pass Parameters or Use Global Variables
- Use Implicit Cursors When Appropriate
- Remember That Dates Are Numbers
-
Chapter 16: Ten Common Mistakes to Avoid in PL/SQL
- Catching an Exception with WHEN OTHERS THEN NULL
- Forgetting to Handle NULL Values
- Creating Unintended Boolean Expressions
- Forgetting to Close an Explicit Cursor
- Starting Endless Loops
- Reinventing the Wheel
- Converting Datatypes Implicitly
- Cutting and Pasting Code
- Ignoring Code Readability
- Assuming Code Doesn’t Need Comments
-
Chapter 15: Ten PL/SQL Tips
Product information
- Title: Oracle PL/SQL For Dummies
- Author(s):
- Release date: June 2006
- Publisher(s): For Dummies
- ISBN: 9780764599576
You might also like
book
Oracle PL/SQL for DBAs
PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 …
video
Oracle PL/SQL
In this training course by Lewis Cunningham on Oracle PL/SQL Programming, you will learn how to …
book
Oracle PL/SQL Programming, Third Edition
Nearly a quarter-million PL/SQL programmers--novices and experienced developers alike--have found the first and second editions of …
video
Learning Oracle PL/SQL
In this Learning Oracle PL/SQL training course, expert author Darryl Hurley will teach you how to …