If you work with Oracle, then you don't need to be told that the data dictionary is large and complex, and grows larger with each new Oracle release. It's one of the basic elements of the Oracle database you interact with regularly, but the sheer number of tables and views makes it difficult to remember which view you need, much less the name of the specific column. Want to make it simpler? The Oracle Data Dictionary Pocket Reference puts all the information you need right at your fingertips. Its handy and compact format lets you locate the table and view you need effortlessly without stopping to interrupt your workOracle Data Dictionary Pocket Reference gives DBAs and developers at any level quick and easy access to the data dictionary in Oracle's latest database, Oracle9i. This pocket-sized book provides a complete list of the most commonly used tables and views in the Oracle9i data dictionary, intelligently arranged for quick reference. It also includes column names and descriptions for each of the tables and views, as well as helpful tips, warnings, and usage examples.O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and want to check your facts quickly, the Oracle Data Dictionary Pocket Reference is the book to have close by.

Osoby które kupowały "Oracle Data Dictionary Pocket Reference", wybierały także:

• PL/SQL. Kurs video. Od podstaw do zagadnieÅ„ zaawansowanych. Programowanie baz danych 79,00 zÅ‚, (31,60 zÅ‚ -60%)
• Linux Server. Kurs video. UsÅ‚ugi serwerowe, skrypty i Å›rodowisko graficzne 69,00 zÅ‚, (34,50 zÅ‚ -50%)
• Tablice informatyczne. SQL. Wydanie III 16,98 zÅ‚, (8,49 zÅ‚ -50%)
• SQL w 24 godziny. Wydanie VI 69,00 zÅ‚, (34,50 zÅ‚ -50%)
• Oracle PL/SQL w mgnieniu oka 44,90 zÅ‚, (22,45 zÅ‚ -50%)

Spis treści

Oracle Data Dictionary Pocket Reference eBook -- spis treści

• Oracle Data Dictionary Pocket Reference
• 1. Introduction
  • Acknowledgments
  • Conventions
  • What Is the Data Dictionary?
  • Sample Queries in This Book
• 2. Static Data Dictionary Views
  • Categories of Views
  • Commonly Used Static Data Dictionary Views
    • Change Data Capture
    • Constraints
    • Data dictionary
    • Indexes
    • Jobs and Advanced Queuing
    • Locks
    • Log groups
    • Materialized views
    • Networking and distributed transactions
    • Objects Option
    • Partitioning
    • Programming and PL/SQL
    • Replication
    • Security and auditing
    • Server information
    • SQLJ
    • Storage
    • Tables, columns, and views
  • Other Static Data Dictionary Views
    • Export/Import
    • Gateways
    • Oracle Parallel Server/Real Application Clusters
    • Remote procedure calls
    • Snapshots
    • SQL*Loader direct path
    • Tablespace point-in-time recovery
• 3. Dynamic Data Dictionary Views
  • Availability of Dynamic Data Dictionary Views
  • How Dynamic Data Dictionary Views Are Built
  • Global Dynamic Data Dictionary Views (GV$ Views)
  • Commonly Used Dynamic Data Dictionary Views
    • Advanced Queuing
    • Configuration
    • Data dictionary cache
    • Database
    • Instance
    • Locks and latches
    • Multi-Threaded Server/Shared Servers
    • Oracle Parallel Server/Real Application Clusters
    • Parallel Query
    • Recovery
    • Replication
    • Resource allocation
    • Security
    • Session
    • System Global Area
    • SQL
    • SQL*Loader direct path
    • System environment
• Index
• About the Author
• Copyright