From Our Readers
Your corrections, your opinions, and your requests: Here’s your forum for telling us what’s right and wrong in each issue of Oracle Magazine, and for letting us know what you want to read.
Note from Steven Feuerstein
Several readers have noticed that I contradicted myself in recent Q&As published in Oracle Magazine and my Oracle PL/SQL Best Practices column. In the Kicking the %NOTFOUND Habit section of "On BULK COLLECT" (Oracle Magazine, March/April 2008, and www.tinyurl.com/b7fkcn), and “On Cursor FOR Loops” (Oracle Magazine, November/December 2008, and www.tinyurl.com/aqwo9j), I recommend a best practice for exiting from a loop fetching with BULK COLLECT LIMIT and then violate my own best practice. Well, only sort of.
So allow me to restate: the wrong way to exit such a loop is to check the %NOTFOUND attribute of your cursor immediately after the fetch statement. Instead, you should check the contents of the collection populated by the BULK COLLECT or check the %NOTFOUND attribute of your cursor at the end of the loop body . Both of these techniques will ensure that all rows are processed; the latter of the two will avoid a final fetch that retrieves no rows.
You Don’t Need Glasses
The printer view does not work for “Keeping Active,” by Arup Nanda (Oracle Magazine, November/December 2008). I have to scale to 50 percent, and then I cannot read the small letters.
Editors reply: The printer view has been adjusted in the HTML version of this article on Oracle Active Data Guard.
Keeping Up with Products
I enjoy scanning the pages of Oracle Magazine but would like to see a department that gives a brief on Oracle’s products (direction and future plans, including “end of life”). I don’t mean at the specific product level, but at the strategic level—with embedded links to specific product offerings. As a CTO, it is always difficult to keep up with what is on offer, what is “retiring,” and what is replacing a product. This is true not only in the Oracle space, but across the board.
We Need More PL/SQL
I liked “On Emulating FINALLY” (Oracle Magazine, January/February 2009) very much. This is really useful to me and has given me a new approach for PL/SQL coding.
I would like to see more articles on PL/SQL in the next issue of Oracle Magazine.
A Better Solution
After reading the Ask Tom column “ Rollups, Merges, and Moves ” (Oracle Magazine, March/April 2005), I tried some examples of view merging in Oracle Database 10g Release 2. For the third query, it merged the view as well as pushed the predicate. Has anything changed in the optimizer regarding view merging?
Tom Kyte replies: Every Oracle Database release will have improvements in the optimizer. Yes, Oracle Database 10g is “better” than Oracle9i Database, and Oracle Database 11g is even better still. This is one reason why every Q&A on AskTom (asktom.oracle.com) has a date/time stamp as well as specific version information, so that you can evaluate its currentness and relevance.