CodeNotes for Oracle 9i

Book excerpt: CodeNotes provides the most succinct, accurate, and speedy way for a developer to ramp up on a new technology or language. Unlike other programming books, CodeNotes drills down to the core aspects of a technology, focusing on the key elements needed in order to implement it immediately. It is a unique resource for developers, filling the gap between comprehensive manuals and pocket references. Through real-world examples of PL/SQL queries, stored procedures, triggers, indexing, and more, CodeNotes for Oracle 9i illustrates the complete Oracle database framework, PL/SQL, security, administration, and optimization. Oracle’s integration with Java and support for XML are extensively covered. This edition of CodeNotes includes: • A global overview of this technology and explanation of what problems it can be used to solve • Real-world examples • “How and Why” and “Bugs and Caveats” sections that provide hints, tricks, workarounds, and tips on what should be taken advantage of or avoided • “Design Notes” illustrating many of the common use patterns for Java programs • Instructions and classroom-style tutorials throughout from expert trainers and software developers Visit www.codenotes.com for updates, source code templates, access to message boards, and discussion of specific problems with CodeNotes authors and other developers. Join our nonfiction newsletter by sending a blank e-mail to: [email protected] or visit www.atrandom.com Every CodeNotes title is written and reviewed by a team of commercial software developers and technology experts. See “About the Authors” at the front of the book for more information.