Wrong-Errors Bugs: A New Class of Bug? Dan Tow has a fascinating proposal to present: the recognition of a new class of database bug, dubbed the wrong-error bug. Dan suggests ways to eliminate most of these bugs while increasing the optimizer's freedom to find the best path to the data. Dan is the author of SQL Tuning.
Using the New MODEL Clause in Oracle Database
10g -- One of the great new features of Oracle
Database 10g is its new MODEL clause. This article looks
at
some examples of the MODEL clause in action, and shows how
to use it to move PL/SQL logic directly into SQL. Practical, expert
best practices for Oracle SQL are outlined in the recently released Mastering Oracle
SQL, 2nd Edition.
Oracle Magazine's Editors' Choice Awards -- O'Reilly authors Cary Millsap and Jeff Holt have been named by Oracle Magazine's editors as Authors of the Year in recognition of their work on the "definitive tuning text," Optimizing Oracle Performance.
Cooking Up a User Interface -- No matter how much you do behind the scenes to create a solid and robust application, users of the application see only your user interface. Chapter 9 of Access Cookbook, 2nd Edition shows you how to design a UI that is workable, aesthetically pleasing, and helps users get their work done. Learn how to take full advantage of special keystrokes, create a map-based interface and forms that carry data forward from record to record, and much more. If you like this chapter, read the whole book (and up to nine others) on Safari with a free trial subscription.
Your O'Reilly Account: New, Single Sign On -- O'Reilly customers and guests now have a single address and one password to access all things O'Reilly, from oreilly.com and Safari Bookshelf to all of the O'Reilly Network sites and DevCenters. When possible, we've consolidated your prior, separate accounts into one new account. Logging into the new system is quick and easy; details on how to do it have been emailed to you, and you can read more about O'Reilly's single sign on in Tony Stubblebine's weblog.
MIN-MAX PL/SQL is a best
practices and optimization seminar by O'Reilly author Steven Feuerstein,
who has selected from Oracle's many new PL/SQL features and his recommended
best practices to create a three-day course that will radically change the
way you design and implement PL/SQL-based applications. Steven has written
many books, including Oracle PL/SQL
Programming, 3rd Edition.
Safari Gets Bigger and Better -- There are now more than 2,000 books from the industry's leading technical publishers available on Safari Bookshelf. As the library grows, so does its functionality: searches are powerfully precise and as broad or specific as you wish; and now, with a Safari Max subscription, you can download chapters to read offline. Safari will help you save time, reduce errors, keep current, and save more money than ever with up to 35% off print copies of your favorite books. If you haven't
yet gone on Safari, try a free trial subscription.