Oracle PL/SQL Best Practices Review

View Review Details

Book:		Oracle PL/SQL Best Practices
Subject:		Oracle PL/SQL Best Practices Review
Date:		2003-07-31 19:23:02
From:		David Laub

Rating: A definitive book. One minor complaint, on the topic of (not) always practicing what is preached. The example in Chapter 5 which uses dynamic SQL to find the nextval for any sequence parses the query EVERY time in a loop - vs. doing this once prior to the loop. Not only does this waste time, but it confuses the issue making it seem like the parse is being done differently every time through the loop.