From Book News, Inc.
The latest version of this popular guide introduces the fundamental commands and techniques used in Oracle 9i database systems, and how to develop applications using Oracle and SQL. The authors also review PL/SQL structures, object-oriented and Java features in the Oracle database, the data dictionary, database optimizers, and the application server. The CD-ROM contains an electronic version of the book and tables.Book News, Inc.®, Portland, OR
Book Description
Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.
Book Info
Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. A must-have for all Oracle professionals. Softcover. CD-ROM included.
From the Back Cover
The Renowned Oracle Resource--Fully Updated for Oracle9i
Get comprehensive information on all the features of Oracle9i. Written by best-selling authors and Oracle gurus Kevin Loney, George Koch, and the experts at TUSC, Oracle9i: The Complete Reference covers critical relational, object-relational, and Web database concepts, as well as SQL, SQL*PLUS, PL/SQL, Java, JDBC, SQLJ, and XML programming. You'll also get full details on database administration techniques--and much more. This authoritative volume is a must-have tool for all Oracle professionals. Use flashback queries to see data as it existed prior to commits Create, query, and manage external tables Create partitions, indexes, and tablespaces Execute and tune SQL queries Produce sophisticated reports using SQL*PLUS Load data from external files into Oracle database tables with SQL*Loader Create triggers, stored procedures, functions, and packages with PL/SQL Implement types, object views, and methods Develop robust database applications with SQLJ, JDBC, and XML Take advantage of the Oracle9i data dictionary and optimizer Tour the components of Oracle9i Application Server (Oracle9iAS) Manage, tune, back up, and recover Oracle9i databases Learn anytime, anywhere with a 90-day Oracle University Professional subscription. Details on CD-ROM
Bonus CD includes fully searchable electronic book, complete listings of all tables, and an Oracle9i "Information & Documentation Kit" featuring Release 2 New Features White Paper and selected documentation.
Oracle9i: The Complete Reference FROM OUR EDITORS
The Barnes & Noble Review
In Oracle 9i: The Complete Reference, legendary Oracle wizard Kevin Loney and former Oracle senior VP George Koch have done it yet again: Theyᄑve authored the most thorough Oracle 9i reference ever created.
Of course, all the latest Oracle 9i functions and commands are covered, both throughout the book and in an extensively cross-referenced Alphabetic Reference thatᄑs unparalleled in its usefulness. Youᄑll find detailed new coverage of Oracle 9iᄑs Virtual Private Database, a remarkably flexible tool for implementing security; as well as Flashback Queries, which allow users to recover from mistakes easily and gracefully. Youᄑll also find new, quick "Hitchhiker's Guides" to the Oracle 9i Data Dictionary, Optimizer, and Application Server, and on Oracle 9iᄑs XML support.
You name it, itᄑs here. After a thorough review of fundamental database concepts, Loney and Koch present 24 full chapters on SQL, SQL*Plus, and PL/SQL. Thatᄑs followed by a complete section on implementing and utilizing object-relational databases, and three full chapters on Java in Oracle -- including coverage of both JDBC and SQLJ programming, as well as Java stored procedures. Only one thingᄑs bigger than this book: its value to the working Oracle professional.
Bill Camarda
Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.
FROM THE PUBLISHER
Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.
SYNOPSIS
The "must have" reference for all Oracle professionals is now updated with
the latest information on Oracle9i.
Master all the powerful features of Oracle9i--the most complete and
comprehensive platform for building and deploying Internet and enterprise
applications. Written by best-selling Oracle author, Kevin Loney, and a
former senior vice president of Oracle Corporation, George Koch, Oracle9i:
The Complete Reference covers all the components of this robust product.
You'll learn new topics core to the 9i release including new functions and
commands, the Virtual Private Database (VPD), and Flashback Queries. There
are also chapters about using related products and technologies such as
Oracle9i Application Server (9iAS) and XML, and much more.
Get full details on critical database concepts, including all of the new
Oracle9i features:
Handle SQL queries and data conversion
Build reports with SQL Plus
Develop robust, Web-enabled PL/SQL applications
Execute object technology in Oracle9i
Implement object technology in Oracle9i
Create multi-platform database applications
with SQLJ and JDBC
Use Oracle9i developer tools, including the
data dictionary and optimizer
Guarantee the security, recoverability, and
availability of the database
Back up, recover, and tune Oracle9i databases
Kevin Loney (Wilmington, DE) is a consultant for TUSC and a veteran Oracle
developer and DBA. He is among the most renowned members of the Oracle
Professional community and is a regular presenter at IOUG-A, Oracle
OpenWorld, and regional User Group conferences. Kevin is the coauthor of
several of our best-selling titles such as Oracle8i: The Complete Reference
and Oracle9i DBA Handbook.
George Koch (Wheaton, IL) is a leading authority on relational database
applications. A popular speaker and widely published author, he is also the
creator of THESIS, the securities trading, accounting, and portfolio
management system that was the first major commercial application product in
the world to employ a relational database (Oracle) and provide an English
language query to its users. He is a former senior vice president of Oracle
Corporation
FROM THE CRITICS
Booknews
The latest version of this popular guide introduces the fundamental commands and techniques used in Oracle 9i database systems, and how to develop applications using Oracle and SQL. The authors also review PL/SQL structures, object-oriented and Java features in the Oracle database, the data dictionary, database optimizers, and the application server. The CD-ROM contains an electronic version of the book and tables. Annotation c. Book News, Inc., Portland, OR