Oracle Database Concepts - Apuntes de Psicología

Oracle9

Database Concepts

Release 2 (9.2)

March 2002

Part No. A96524-01

Vista previa parcial del texto

¡Descarga Oracle Database Concepts y más Apuntes en PDF de Psicología solo en Docsity!

Oracle9i

Database Concepts Release 2 (9.2)

March 2002Part No. A96524-

Oracle9Part No. A96524-01 i Database Concepts, Release 2 (9.2) Copyright © 1996, 2002 Oracle Corporation. All rights reserved.Primary Author: Michele Cyran Contributors: Lance Ashdown, Cathy Baird, Sandeepan Banerjee, Mark Bauer, Ruth Baylis, PradeepBhanot, Janet Blowney, Allen Brumm, Ted Burroughs, Larry Carpenter, Donna Carver, ChandraChandrasekar, Gary Chen, Amit Ganesh, Tom Grant, Mike Hartstein, John Haydu, Susan Hillson, Dominique Jeunot, Archna Kalra Johnson, Vishy Karra, Alex Keh, Susan Kotsovolos, Sushil Kumar,Tirthankar Lahiri, Paul Lane, Simon Law, Jeff Levinger, Yunrui Li, Bryn Llewellyn, Diana Lorentz, LenoreLuscher, Sheryl Maring, Ben Meng, Kuassi Mensah, Tony Morales, Ari Mozes, Subramanian Muralidhar, Ravi Murthy, Sujatha Muthulingam, Gary Ngai, Kant Patel, Ananth Raghavan, Jack Raitto, BeckReitmeyer, Ann Rhee, Kathy Rich, John Russell, Vivian Schupmann, Ravi Shankar, Mark Smith, RichardSmith, Ekrem Soylemez, Marie St. Gelais, Debbie Steiner, Bob Thome, Anh-Tuan Tran, Randy Urbano, Stephen Vivian, Daniel Wong, Wanli Yang, Ruiling Zhang, ZulaikhaGraphic Designer: Valarie Moore The Programs (which include both the software and documentation) contain proprietary information ofOracle Corporation; they are provided under a license agreement containing restrictions on use anddisclosure and are also protected by copyright, patent and other intellectual and industrial property laws. Reverse engineering, disassembly or decompilation of the Programs, except to the extent requiredto obtain interoperability with other independently created software or as specified by law, is prohibited. The information contained in this document is subject to change without notice. If you find any problemsin the documentation, please report them to us in writing. Oracle Corporation does not warrant that thisdocument is error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means,electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation. If the Programs are delivered to the U.S. Government or anyone licensing or using the programs onbehalf of the U.S. Government, the following notice is applicable: Restricted Rights Notice computer software" and use, duplication, and disclosure of the Programs, including documentation,shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Programs delivered subject to the DOD FAR Supplement are "commercial Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computersoftware" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,redundancy, and other measures to ensure the safe use of such applications if the Programs are used forsuch purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the Programs.Oracle is a registered trademark, and Oracle9 i , Oracle8 i , Oracle7, Oracle Store, Oracle Transparent Gateway, PL/SQL, ProC, ProCobol, ProC/C++, Express, SQLNet, and SQL*Plus are trademarks orregistered trademarks of Oracle Corporation. Other names may be trademarks of their respectiveowners.

iv

SQL Overview SQL Statements 1-101-
Objects Overview........................................................................................................................ Advantages of Objects 1-121-
PL/SQL Overview...................................................................................................................... PL/SQL Program Units 1-131-
Java Overview XML Overview............................................................................................................................ 1-141-
Transactions Overview Commit and Roll Back Transactions................................................................................. 1-171-
- Savepoints............................................................................................................................. Data Consistency Using Transactions 1-191-
Data Integrity Overview Integrity Constraints 1-191-
SQL*Plus Overview.................................................................................................................... Keys 1-201-
Memory Structure and Processes Overview An Oracle Instance...................................................................................................................................................................................................... 1-211-
- Memory Structures Real Application Clusters: Multiple Instance Systems 1-241-
  - System Global Area Program Global Area 1-251-
- Process Architecture................................................................................................................... User (Client) Processes........................................................................................................ 1-261-
- The Program Interface Mechanism Oracle Processes................................................................................................................... 1-271-
- An Example of How Oracle Works.......................................................................................... Communications Software and Oracle Net Services...................................................... 1-301-
Application Architecture Overview Client/Server Architecture........................................................................................................ 1-321- - The Client.............................................................................................................................. The Server 1-321-
Distributed Databases Overview Multitier Architecture: Application Servers 1-321- - Location Transparency 1- - Site Autonomy Distributed Data Manipulation 1-341- v
- Replication Overview Two-Phase Commit............................................................................................................. 1-341-
  - Table Replication Multitier Materialized Views............................................................................................. 1-351-
- Streams Overview Advanced Queuing Overview.................................................................................................. 1-361-
Data Concurrency and Consistency Overview Heterogeneous Services Overview 1-391-
- Concurrency Read Consistency........................................................................................................................ 1-401-
  - Read Consistency, Undo Records, and Transactions..................................................... Read-Only Transactions 1-411-
- Locking Mechanisms.................................................................................................................. Automatic Locking.............................................................................................................. 1-421-
- Quiesce Database........................................................................................................................ Manual Locking................................................................................................................... 1-421-
Database Security Overview Security Mechanisms 1-431- - Database Users and Schemas............................................................................................. Privileges 1-451- - Roles Storage Settings and Quotas 1-461- - Profiles and Resource Limits Selective Auditing of User Actions................................................................................... 1-471-
Database Administration Overview Fine-Grained Auditing 1-491-
- Enterprise Manager Overview Database Backup and Recovery Overview............................................................................. 1-491-
  - Why Recovery Is Important............................................................................................... Types of Failures.................................................................................................................. 1-501-
Data Warehousing Overview Structures Used for Recovery 1-521-
- Differences Between Data Warehouse and OLTP Systems.................................................. 1- - Workload Data Modifications 1-541- vi - Schema Design Typical Operations 1-541-
  - Data Warehouse Architecture................................................................................................... Historical Data 1-551-
    - Data Warehouse Architecture (Basic)............................................................................... Data Warehouse Architecture (with a Staging Area)..................................................... 1-551-
  - Materialized Views..................................................................................................................... Data Warehouse Architecture (with a Staging Area and Data Marts) 1-571-
  - OLAP Overview.......................................................................................................................... Change Data Capture Overview 1-581-
- High Availability Overview Transparent Application Failover 1-601-
  - Online Reorganization Architecture Elements Affected by Transparent Application Failover 1-611-
  - Data Guard Overview................................................................................................................ Data Guard Configurations 1-631-
  - LogMiner Overview Data Guard Components 1-631-
  - Real Application Clusters Real Application Clusters Guard 1-651-
- Content Management Overview Oracle Internet File System Overview 1-671-
2 Data Blocks, Extents, and Segments Introduction to Data Blocks, Extents, and Segments 2- Part II Database Structures
- Data Blocks Overview Data Block Format 2-32- - Header (Common and Variable) Table Directory....................................................................................................................... 2-42- - Row Directory Overhead 2-52- - Row Data Free Space 2-52- vii
  - Free Space Management Availability and Compression of Free Space in a Data Block......................................... 2-62-
    - Row Chaining and Migrating.............................................................................................. PCTFREE, PCTUSED, and Row Chaining......................................................................... 2-72-
- Extents Overview When Extents Are Allocated....................................................................................................... 2-82-
  - Determine the Number and Size of Extents How Extents Are Allocated......................................................................................................... 2-82-
  - When Extents Are Deallocated................................................................................................. Extents in Nonclustered Tables......................................................................................... 2-102-
    - Extents in Clustered Tables................................................................................................ Extents in Materialized Views and Their Logs 2-112-
    - Extents in Indexes................................................................................................................ Extents in Temporary Segments 2-112-
- Segments Overview Extents in Rollback Segments 2-122-
  - Introduction to Data Segments................................................................................................. Introduction to Index Segments 2-122-
  - Introduction to Temporary Segments Operations that Require Temporary Segments 2-132-
    - Segments in Temporary Tables and Their Indexes How Temporary Segments Are Allocated 2-142-
  - Automatic Undo Management................................................................................................. Undo Mode 2-162-
    - Undo Quota.......................................................................................................................... Undo Retention Control 2-172-
    - External Views 2-
3 Tablespaces, Datafiles, and Control Files Introduction to Tablespaces, Datafiles, and Control Files 3- - Oracle-Managed Files Allocate More Space for a Database 3-33-
- Tablespaces Overview 3-
  - The SYSTEM Tablespace.............................................................................................................. The Data Dictionary 3-73- viii
  - Undo Tablespaces PL/SQL Program Units Description 3-83-
    - Creation of Undo Tablespaces Assignment of Undo Tablespaces 3-93-
  - Default Temporary Tablespace................................................................................................. How to Specify a Default Temporary Tablespace 3-103-
  - Using Multiple Tablespaces Managing Space in Tablespaces 3-103-
    - Locally Managed Tablespaces Segment Space Management in Locally Managed Tablespaces................................... 3-113-
  - Multiple Block Sizes Dictionary Managed Tablespaces 3-133-
  - Online and Offline Tablespaces................................................................................................ When a Tablespace Goes Offline....................................................................................... 3-133-
  - Read-Only Tablespaces.............................................................................................................. Use of Tablespaces for Special Procedures 3-143-
  - Temporary Tablespaces for Sort Operations Sort Segments 3-163-
  - Transport of Tablespaces Between Databases Creation of Temporary Tablespaces 3-163-
- Datafiles Overview How to Move or Copy a Tablespace to Another Database 3-173-
  - Datafile Contents Size of Datafiles 3-183-
  - Offline Datafiles Temporary Datafiles................................................................................................................... 3-193-
- Control Files Overview Control File Contents 3-203-
  - Multiplexed Control Files.......................................................................................................... 3-
4 The Data Dictionary Introduction to the Data Dictionary 4- - Structure of the Data Dictionary................................................................................................. 4- - Base Tables User-Accessible Views.......................................................................................................... 4-34- ix
- How the Data Dictionary Is Used SYS, Owner of the Data Dictionary................................................................................................................................................................................................ 4-34-
  - How Oracle Uses the Data Dictionary Public Synonyms for Data Dictionary Views.................................................................... 4-34-
    - Cache the Data Dictionary for Fast Access Other Programs and the Data Dictionary.......................................................................... 4-44-
  - How to Use the Data Dictionary Views with the Prefix USER 4-54-
    - Views with the Prefix ALL................................................................................................... Views with the Prefix DBA 4-64-
- Dynamic Performance Tables The DUAL Table.................................................................................................................... 4-64-
- Database Object Metadata 4-
5 Database and Instance Startup and Shutdown Introduction to an Oracle Instance 5- Part III The Oracle Instance - The Instance and the Database Connection with Administrator Privileges............................................................................... 5-35- - Initialization Parameter Files How Parameter Values Are Changed 5-45-
- Instance and Database Startup How an Instance Is Started................................................................................................................................................................................................................... 5-55- - Restricted Mode of Instance Startup Forced Startup in Abnormal Situations 5-65-
  - How a Database Is Mounted....................................................................................................... How a Database Is Mounted with Real Application Clusters 5-65-
    - How a Standby Database Is Mounted................................................................................ How a Clone Database Is Mounted 5-75-
  - What Happens When You Open a Database............................................................................ Instance Recovery.................................................................................................................. 5-85-
    - Undo Space Acquisition and Management 5-
    - Resolution of In-Doubt Distributed Transaction Open a Database in Read-Only Mode 5-95- x
- Database and Instance Shutdown Close a Database 5-105-
  - Unmount a Database.................................................................................................................. Close the Database by Terminating the Instance............................................................ 5-105-
  - Shut Down an Instance Abnormal Instance Shutdown........................................................................................... 5-115-
6 Application Architecture Client/Server Architecture 6-
- Multitier Architecture Clients............................................................................................................................................. 6-56-
  - Application Servers Database Servers 6-66-
- Oracle Net Services Connectivity 6-76- - Manageability......................................................................................................................... Internet Scalability................................................................................................................. 6-86-
  - How Oracle Net Services Works Internet Security..................................................................................................................... 6-86-
  - The Listener Service Information Registration......................................................................................... 6-96-
7 Memory Architecture Introduction to Oracle Memory Structures 7-
- System Global Area (SGA) Overview Dynamic SGA................................................................................................................................ 7-37-
  - Database Buffer Cache Dynamic SGA Granules........................................................................................................ 7-57-
    - Organization of the Database Buffer Cache The LRU Algorithm and Full Table Scans 7-77-
    - Size of the Database Buffer Cache....................................................................................... Multiple Buffer Pools 7-107-
  - Redo Log Buffer 7-
  - Shared Pool.................................................................................................................................. Library Cache....................................................................................................................... 7-117- xi
    - Shared SQL Areas and Private SQL Areas PL/SQL Program Units and the Shared Pool 7-127-
    - Dictionary Cache Allocation and Reuse of Memory in the Shared Pool 7-137-
  - Large Pool Control of the SGA’s Use of Memory...................................................................................... 7-157-
  - Other SGA Initialization Parameters Physical Memory................................................................................................................. 7-167-
    - SGA Starting Address......................................................................................................... Extended Buffer Cache Mechanism.................................................................................. 7-167-
- Program Global Areas (PGA) Overview Content of the PGA 7-177- - Private SQL Area Session Memory................................................................................................................... 7-177-
  - SQL Work Areas PGA Memory Management for Dedicated Mode 7-197-
- Dedicated and Shared Servers Software Code Areas 7-227-
8 Process Architecture Introduction to Processes 8- - Multiple-Process Oracle Systems Types of Processes 8-28-
- User Processes Overview Connections and Sessions 8-48-
- Oracle Processes Overview Server Processes............................................................................................................................ 8-58-
  - Background Processes.................................................................................................................. Database Writer Process (DBW n ) 8-58-
    - Log Writer Process (LGWR) Checkpoint Process (CKPT)............................................................................................... 8-118-
    - System Monitor Process (SMON) Process Monitor Process (PMON) 8-118-
    - Recoverer Process (RECO) Job Queue Processes............................................................................................................ 8-128- xii
    - Archiver Processes (ARC Lock Manager Server Process (LMS) n ) 8-138-
  - Trace Files and the Alert Log Queue Monitor Processes (QMN n )................................................................................... 8-148-
- Shared Server Architecture Scalability 8-158-
  - Dispatcher Request and Response Queues............................................................................. Dispatcher Processes (D nnn ).............................................................................................. 8-168-
  - Shared Server Processes (S Restricted Operations of the Shared Server nnn ) 8-198-
- Dedicated Server Configuration The Program Interface 8-218-
  - Program Interface Structure...................................................................................................... Program Interface Drivers 8-238-
  - Communications Software for the Operating System........................................................... 8-
9 Database Resource Management Introduction to the Database Resource Manager 9- - Database Resource Manager Overview Example of a Simple Resource Plan 9-39-
- How the Database Resource Manager Works Resource Control........................................................................................................................... 9-59- - Example of Resource Control Effectiveness of the Database Resource Manager............................................................. 9-59-
  - Database Integration Performance Overhead 9-69-
- Resource Plans and Resource Consumer Groups Activation of a Resource Plan 9-79- - Persistent................................................................................................................................. Dynamic 9-89-
- Resource Allocation Methods and Resource Plan Directives Groups of Resource Plans............................................................................................................ 9-119-
  - Resource Plan Directives 9-
    - CPU Method......................................................................................................................... Active Session Pool with Queuing.................................................................................... 9-129- xiii
    - Degree of Parallelism Limit Automatic Consumer Group Switching 9-129-
    - Execution Time Limit.......................................................................................................... Undo Pool............................................................................................................................. 9-139-
  - CPU Resource Allocation CPU Allocation Rules 9-139-
- Interaction with Operating-System Resource Control Levels and Priorities.......................................................................................................................................................................... 9-169-
  - Dynamic Reconfiguration 9-
10 Introduction to Schema ObjectsSchema Objects 10- Part IV Data
- Tables How Table Data Is Stored............................................................................................................................................................................................................................................................. 10-510- - Row Format and Size Rowids of Row Pieces......................................................................................................... 10-610-
  - Nulls Indicate Absence of Value Column Order...................................................................................................................... 10-1010-
  - Default Values for Columns.................................................................................................... Default Value Insertion and Integrity Constraint Checking....................................... 10-1010-
  - Partitioned Tables..................................................................................................................... Nested Tables 10-1210-
  - Temporary Tables..................................................................................................................... Segment Allocation 10-1310-
  - External Tables.......................................................................................................................... Parent and Child Transactions 10-1410-
    - The Access Driver.............................................................................................................. Data Loading with External Tables 10-1510-
- Views Parallel Access to External Tables................................................................................... 10-1610-
  - How Views are Stored 10-
- How Views Are Used............................................................................................................... Mechanics of Views 10-1810- xiv
  - Globalization Support Parameters in Views Use of Indexes Against Views 10-1910-
- Dependencies and Views......................................................................................................... Updatable Join Views............................................................................................................... 10-2010-
- Object Views Inline Views 10-2110-
Materialized Views Define Constraints on Views............................................................................................................................................................................................................................ 10-2210-
- Refresh Materialized Views Materialized View Logs 10-2410-
Dimensions The Sequence Generator 10-2510-
Synonyms Indexes 10-2710-
- Unique and Nonunique Indexes Composite Indexes 10-3010-
- Indexes and Keys Indexes and Nulls 10-3110-
- Function-Based Indexes Uses of Function-Based Indexes...................................................................................... 10-3210-
  - Optimization with Function-Based Indexes Dependencies of Function-Based Indexes 10-3310-
- How Indexes Are Stored.......................................................................................................... Format of Index Blocks 10-3410-
  - The Internal Structure of Indexes.................................................................................... Index Properties................................................................................................................. 10-3510-
- How Indexes Are Searched Advantages of B-tree Structure 10-3710-
  - Index Unique Scan............................................................................................................. Index Range Scan............................................................................................................... 10-3810-
- Key Compression...................................................................................................................... Index Range Scan Descending......................................................................................... 10-4310-
  - Prefix and Suffix Entries 10-
    - Performance and Storage Considerations Uses of Key Compression 10-4610- xv
  - Reverse Key Indexes Bitmap Indexes.......................................................................................................................... 10-4710-
    - Benefits for Data Warehousing Applications................................................................ Cardinality.......................................................................................................................... 10-4810-
    - Bitmap Index Example Bitmap Indexes and Nulls................................................................................................ 10-5010-
  - Bitmap Join Indexes.................................................................................................................. Bitmap Indexes on Partitioned Tables............................................................................ 10-5310-
    - Four Join Models Creation of a Bitmap Join Index 10-5310-
- Index-Organized Tables Benefits of Index-Organized Tables....................................................................................... 10-5710-
  - Index-Organized Tables with Row Overflow Area............................................................. Secondary Indexes on Index-Organized Tables................................................................... 10-5910-
  - Bitmap Indexes on Index-Organized Tables Mapping Table................................................................................................................... 10-6110-
  - Partitioned Index-Organized Tables...................................................................................... B-tree Indexes on UROWID Columns for Heap- and Index-Organized Tables 10-6210-
- Application Domain Indexes Index-Organized Table Applications 10-6210-
- Clusters Hash Clusters 10-6310-
11 Introduction to PartitioningPartitioned Tables and Indexes 11- - Partition Key................................................................................................................................ Partitioned Tables....................................................................................................................... 11-411-
- Partitioning Methods Partitioned Index-Organized Tables........................................................................................ 11-511-
  - Range Partitioning...................................................................................................................... Range Partitioning Example 11-711-
  - List Partitioning List Partitioning Example................................................................................................... 11-811-
  - Hash Partitioning........................................................................................................................ Hash Partitioning Example 11-1011- xvi
  - Composite Partitioning Composite Partitioning Range-Hash Example 11-1011-
  - When to Partition a Table Composite Partitioning Range-List Example 11-1211-
- Partitioned Indexes Local Partitioned Indexes 11-1311-
  - Global Partitioned Indexes Maintenance of Global Partitioned Indexes 11-1511-
  - Global Nonpartitioned Indexes Partitioned Index Examples 11-1711-
    - Example of Index Creation: Starting Table Used for Examples Example of a Local Index Creation 11-1811-
    - Example of a Global Index Creation............................................................................... Example of a Global Partitioned Index Creation 11-1811-
  - Miscellaneous Information about Creating Indexes on Partitioned Tables Example of a Partitioned Index-Organized Table Creation 11-1911-
  - Using Partitioned Indexes in OLTP Applications................................................................ Using Partitioned Indexes in Data Warehousing and DSS Applications......................... 11-1911-
- Partitioning to Improve Performance Partitioned Indexes on Composite Partitions....................................................................... 11-2011-
  - Partition Pruning Partition Pruning Example............................................................................................... 11-2011-
  - Partition-wise Joins................................................................................................................... Parallel DML.............................................................................................................................. 11-2111-
12 Introduction to Oracle DatatypesNative Datatypes 12-
- Character Datatypes CHAR Datatype 12-312-
  - VARCHAR2 and VARCHAR Datatypes VARCHAR Datatype 12-412-
  - Length Semantics for Character Datatypes............................................................................. NCHAR and NVARCHAR2 Datatypes 12-412-
  - NCHAR................................................................................................................................. NVARCHAR2 12-612- xvii
- Use of Unicode Data in an Oracle Database Implicit Type Conversion................................................................................................... 12-612-
- LOB Character Datatypes.......................................................................................................... LONG Datatype.......................................................................................................................... 12-712-
NUMBER Datatype Internal Numeric Format........................................................................................................... 12-812-
DATE Datatype Use of Julian Dates 12-1012-
- Date Arithmetic......................................................................................................................... Centuries and the Year 2000 12-1112-
- Daylight Savings Support Time Zones 12-1212-
LOB Datatypes Example: 12-1312-
- BLOB Datatype CLOB and NCLOB Datatypes 12-1412-
RAW and LONG RAW Datatypes BFILE Datatype 12-1512-
ROWID and UROWID Datatypes The ROWID Pseudocolumn................................................................................................................................................................................................... 12-1612-
- Physical Rowids........................................................................................................................ Extended Rowids............................................................................................................... 12-1712-
  - Restricted Rowids.............................................................................................................. Examples of Rowid Use.................................................................................................... 12-1912-
- Logical Rowids.......................................................................................................................... How Rowids Are Used..................................................................................................... 12-2112-
  - Comparison of Logical Rowids with Physical Rowids................................................ Guesses in Logical Rowids............................................................................................... 12-2212-
ANSI, DB2, and SQL/DS Datatypes Rowids in Non-Oracle Databases 12-2312-
XML Datatypes XMLType Datatype 12-2512-
URI Datatypes 12-
- Data Conversion 12- xviii
13 Introduction to Object DatatypesObject Datatypes and Object Views 13- - Complex Data Models................................................................................................................ Complex Data Model Example.......................................................................................... 13-213-
- Object Datatype Categories Multimedia Datatypes 13-313-
  - Object Types Purchase Order Example.................................................................................................... 13-413-
    - Types of Methods Object Tables 13-513-
    - Object Identifiers.................................................................................................................. Object Views Description 13-913-
  - Collection Types........................................................................................................................ REFs 13-1113-
    - VARRAYs Nested Tables Description 13-1113-
- Type Inheritance FINAL and NOT FINAL Types 13-1313-
  - NOT INSTANTIABLE Types and Methods Example of Creating a NOT FINAL Object Type 13-1413-
- User-Defined Aggregate Functions Why Have User-Defined Aggregate Functions?.................................................................. 13-1513-
  - Creation and Use of UDAGs................................................................................................... How Do Aggregate Functions Work? 13-1513-
- Application Interfaces SQL.................................................................................................................................................................................................................................................................. 13-1713-
  - PL/SQL Pro*C/C++................................................................................................................................. 13-1813-
  - OCI Dynamic Creation and Access of Type Descriptions 13-1913-
  - OTT JPublisher 13-2013-
  - JDBC............................................................................................................................................ 13-
  - SQLJ SQLJ Object Types............................................................................................................. 13-2113- xix
- Datatype Evolution Introduction to Object Views 13-2213-
  - Advantages of Object Views How Object Views Are Defined 13-2313-
  - Use of Object Views.................................................................................................................. Updates of Object Views 13-2513-
  - Updates of Nested Table Columns in Views........................................................................ View Hierarchies 13-2613-
14 SQL OverviewSQL, PL/SQL, and Java 14- Part V Data Access - SQL Statements Data Manipulation Language Statements 14-214- - Data Definition Language Statements.............................................................................. Transaction Control Statements 14-414- - Session Control Statements................................................................................................ System Control Statements 14-514- - Identification of Nonstandard SQL Embedded SQL Statements 14-514- - Recursive SQL Cursors 14-614- - Shared SQL Scrollable Cursors................................................................................................................ 14-714- - Parsing.......................................................................................................................................... SQL Processing 14-714- - SQL Statement Execution DML Statement Processing.............................................................................................. 14-1014- - DDL Statement Processing............................................................................................... Control of Transactions 14-1414- - The Optimizer Overview......................................................................................................... Execution Plans.................................................................................................................. 14-1414-
- PL/SQL Overview How PL/SQL Runs 14-1614- xx - Native Execution................................................................................................................ Interpreted Execution 14-1714-
  - Language Constructs for PL/SQL.......................................................................................... Variables and Constants 14-1914-
    - Cursors Exceptions........................................................................................................................... 14-1914-
  - PL/SQL Program Units Dynamic SQL in PL/SQL................................................................................................. 14-2014-
    - Stored Procedures and Functions PL/SQL Packages.............................................................................................................. 14-2114-
  - PL/SQL Collections and Records........................................................................................... Collections 14-3014-
  - PL/SQL Server Pages............................................................................................................... Records................................................................................................................................ 14-3014-
- Java Overview Java and Object-Oriented Programming Terminology......................................................................................................................................................................................... 14-3114-
  - Class Hierarchy Classes 14-3214-
  - Interfaces Polymorphism 14-3514-
  - The Java Virtual Machine (JVM)............................................................................................. Why Use Java in Oracle?.......................................................................................................... 14-3714-
    - Multithreading Automated Storage Management 14-4014-
    - Footprint Performance........................................................................................................................ 14-4114-
  - Oracle’s Java Application Strategy......................................................................................... Dynamic Class Loading.................................................................................................... 14-4314-
    - Java Stored Procedures PL/SQL Integration and Oracle RDBMS Functionality 14-4514-
15 Introduction to Dependency IssuesDependencies Among Schema Objects 15-

Oracle Database Concepts, Apuntes de Psicología

Documentos relacionados

Vista previa parcial del texto

¡Descarga Oracle Database Concepts y más Apuntes en PDF de Psicología solo en Docsity!

Oracle9i

iv