Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)
The Ultimate Resource on Oracle Database 10gGet thorough coverage of Oracle Database 10gfrom the most comprehensive reference available, published by Oracle Press. With in-depth details on all the new features, this powerhouse resource provides an overview of database architecture and Oracle Grid Computing technology, and covers SQL, SQL*Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java programming in the Oracle environment. You&#8217;ll also find valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions, with cross-referencing of topics.Install Oracle Database 10gor upgrade from an earlier versionExecute SQL queriesPerform complex searches easily with regular expression functionsImplement security measures using Virtual Private Databases (VPDs)Move data with SQL*Loader and Data PumpReplicate data and aggregations using materialized viewsExecute flashback queries to recover data or see its changes over timeCreate triggers, stored procedures, and packages with PL/SQLDevelop applications with JDBC and XMLWork with Oracle Database 10gReal Application Clusters (RAC) and grid technologiesTake advantage of the new tuning featuresCD-ROM includes a searchable electronic book and all code examples from the book.About the Author: Kevin Loney is a senior technical management consultant with TUSC, a Chicago-based consultancy providing Oracle solutions. He has been an Oracle developer and DBA since 1987, and has written for Oracle Magazine and Oracle Press since 1990. In 2002, he was named Oracle Magazine&#8217;s Editors&#8217; Choice as Consultant of the Year. He is a frequent and highly rated speaker at local and international Oracle user groups.