Oracle 9i Database

This 1,000-page book enables a beginner or intermediate level Oracle DBA or Oracle Developer/Manager to master the art of building and managing complex Oracle 9i databases.

The Oracle server. Database objects. Oracle enterprise manager. Distributed computing. Forms and reports overview. Partitioning data.

This is the only authorized Oracle exam preparation for upgrading an Oracle8ito and Oracle9i certification, from the creators of Oracle certification bookstudy. The book focuses exclusively on the upgrade material need.

Annotation Find out how to use Oracle9i to get a business where it needs to be for the future of the Internet. Learn the ins and outs of the Oracle9i development environment from product installation to advanced management configuration. Extend Oracle9i's functionality using the new database environment including: forms, reports, and Web sites built with PL/SQL, Java, XML, and Portal. Increase business interactivity with Oracle9i's new administrative features. Coverage of the following in an easy to learn format: building, monitoring, and tuning an Oracle9i database; learning the enhanced partitioning features of Oracle9i; building Web sites using Oracle9i and PL/SQL, Java, and XML; building forms and reports using Developer 6i; using the popular TOAD development tool; understanding newer tools such as Log Miner; and comprehensive tutorials on SQL and PL/SQL. Dan Hotka is a director of database field operations for Quest Software. He has more than 23 years of experience in the computer industry and more than 18 years of experience with Oracle products. He's an acknowledged Oracle expert, with Oracle experience dating back to the Oracle v4.0 days. His last book is Oracle8i from Scratch (Que) and he has co-authored the popular books Oracle Unleashed, Oracle8 Server Unleashed, Oracle Development Unleashed (all from Sams Publishing), and Special Edition Using Oracle8/8i (Que Publishing). Dan is frequently published in Oracle Professional, and regularly speaks at Oracle conferences and user groups around the world.

This is the only definitive guide to JDBC programming with Oracle8i and 9i. JDBC is the de facto method for accessing an Oracle database from Java.

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.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Get complete coverage of STATSPACK—Oracle’s powerful tuning tool--inside this official guide Including ready-to-use STATSPACK scripts you’ll be able to collect and analyze system data and soon have your Oracle database running at peak performance.