Synopses & Reviews
The Ultimate Resource on Oracle Database 10
gGet thorough coverage of Oracle Database 10g from 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. Youll 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 10g or upgrade from an earlier version
- Execute SQL queries
- Perform complex searches easily with regular expression functions
- Implement security measures using Virtual Private Databases (VPDs)
- Move data with SQL*Loader and Data Pump
- Replicate data and aggregations using materialized views
- Execute flashback queries to recover data or see its changes over time
- Create triggers, stored procedures, and packages with PL/SQL
- Develop applications with JDBC and XML
- Work with Oracle Database 10g Real Application Clusters (RAC) and grid technologies
- Take advantage of the new tuning features
CD-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 Magazines Editors Choice as Consultant of the Year. He is a frequent and highly rated speaker at local and international Oracle user groups.
Synopsis
The simple and clear language of this book helps establish a common vocabulary that both end users and developers can apply to coherently share concepts and ensure the success of development efforts. The book will cover new topics core to the 9i release including new functions and commands, the Virtual Private Database (VPD), and Flashback Queries.
Synopsis
Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.
Synopsis
The Renowned Oracle Resource--Fully Updated for Oracle9
iGet 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 "InformationandDocumentation Kit" featuring Release 2 New Features White Paper and selected documentation.
About the Author
Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine.
Table of Contents
PART I: Critical Database Concepts
Chapter 1: Oracle Database 10g Architecture Options
Chapter 2: Installing Oracle Database 10g and Creating a Database
Chapter 3: Upgrading to Oracle Database 10g
Chapter 4: Planning Oracle ApplicationsApproaches, Risks, and Standards
PART II: SQL and SQL*Plus
Chapter 5: The Basic Parts of Speech in SQL
Chapter 6: Basic SQL*Plus Reports and Commands
Chapter 7: Getting Text Information and Changing It
Chapter 8: Searching for Regular Expressions
Chapter 9: Playing the Numbers
Chapter 10: Dates: Then, Now, and the Difference
Chapter 11: Conversion and Transformation Functions
Chapter 12: Grouping Things Together
Chapter 13: When One Query Depends upon Another
Chapter 14: Some Complex Possibilities
Chapter 15: Changing Data insert, update, merge, and delete
Chapter 16: DECODE and CASE: if, then, and else in SQL
Chapter 17: Creating and Managing Tables, Views, Indexes, Clusters, and Sequences
Chapter 18: Basic Oracle Security
PART III: Beyond the Basics
Chapter 19: Advanced SecurityVirtual Private Databases
Chapter 20: Working with Tablespaces
Chapter 21: Using SQL*Loader to Load Data
Chapter 22: Using Data Pump Export and Import
Chapter 23: Accessing Remote Data
Chapter 24: Using Materialized Views
Chapter 25: Using Oracle Text for Text Searches
Chapter 26: Using External Tables
Chapter 27: Using Flashback Queries
Chapter 28: FlashbackTables and Databases
PART IV: PL/SQL
Chapter 29: An Introduction to PL/SQL
Chapter 30: Triggers
Chapter 31: Procedures, Functions, and Packages
Chapter 32: Using Native Dynamic SQL and DBMS_SQL
PART V: Object-Relational Databases
Chapter 33: Implementing Types, Object Views, and Methods
Chapter 34: Collectors (Nested Tables and Varying Arrays)
Chapter 35: Using Large Objects
Chapter 36: Advanced Object-Oriented Concepts
PART VI: Java in Oracle
Chapter 37: An Introduction to Java
Chapter 38: JDBC Programming
Chapter 39: Java Stored Procedures
PART VII: Clustered OracleThe Grid
Chapter 40: Oracle Real Application Clusters
Chapter 41: Grid Architecture and Management
PART VIII: Hitchhikers Guides
Chapter 42: The Hitchhikers Guide to the Oracle Data Dictionary
Chapter 43: The Hitchhikers Guide to Tuning Applications and SQL
Chapter 44: Case Studies in Tuning
Chapter 45: The Hitchhikers Guide to Oracle Application Server 10g
Chapter 46: The Hitchhikers Guide to Database Administration
Chapter 47: The Hitchhikers Guide to XML in Oracle
Appendix: Alphabetical Reference