Chapter 15
Ten PL/SQL Tips
In This Chapter
Using SELECT INTO with exception handling
Listing columns explicitly in DML statement
Using the NOCOPY hint for IN OUT parameters
Making efficient function calls
Using DDL commits
Limiting functions to one return statement
Passing parameters
Debugging with WHEN OTHERS in the right way
Knowing when to use implicit and explicit cursors
Working with dates as numbers
Experienced PL/SQL developers can give you hundreds of tips based on their programming ...
Get Oracle PL/SQL For Dummies 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.