Oracle 10g Release 2 (10.2) SQL Reference Manual B14200-02: Dec 2005 Edition

需积分: 7 107 浏览量更新于2024-07-21 收藏 10.33MB PDF 举报

Oracle Database 10g Release 2 (10.2) B14200-02 是 Oracle 公司在 2005 年 12 月发布的一份重要的技术文档，该文档详细介绍了 Oracle 数据库 10g 的第二版。这份 SQL 参考手册是数据库管理员、开发人员和其他 IT 专业人员的重要参考资料，它涵盖了 Oracle 10g 的核心功能、SQL 语言特性以及高级管理工具。本书由 Diana Lorentz 主导编写，她在这份作品中扮演了主要作者的角色。值得一提的是，Lex de Haan 被特别感谢，他在过去的十多年里一直是本书管理方面的重要信息源和灵感来源。其他众多贡献者包括 Sundeep Abraham、Drew Adams 等，他们共同确保了内容的专业性和全面性。 Oracle Database 10g Release 2 在设计上注重性能优化、安全性增强和易用性改进。它支持先进的数据类型、复杂的查询处理能力、并发控制和事务管理，使得用户可以更有效地管理和分析大量数据。SQL Reference 部分详细讲解了 SQL 语言的最佳实践，包括基本语法、高级查询操作、存储过程、函数、索引以及优化查询性能的方法。此外，书中还涵盖了许多实用的管理工具和技术，如备份与恢复、性能监控、数据库分区、网络配置以及与 Oracle 企业应用集成（EAI）相关的知识。版权信息表明，所有权利都归 Oracle 公司所有，强调了尊重知识产权的重要性。对于数据库管理员而言，这份文档是不可或缺的学习资源，无论是初次接触 Oracle 的新手还是经验丰富的专家，都能从中获取深入的理论知识和实践经验。通过阅读和研究这份 SQL Reference，用户可以提升自己的技能，更好地应对企业级数据库管理的挑战。 Oracle Database 10g Release 2 B14200-02 是 Oracle 数据库领域的重要参考资料，为 IT 专业人士提供了详尽的 SQL 技术指南和管理策略，帮助他们在日益复杂的数据环境中保持竞争力。

xvi

ALTER INDEX .................................................................................................................................... 10-64

ALTER INDEXTYPE .......................................................................................................................... 10-82

ALTER JAVA ........................................................................................................................................ 10-84

11 SQL Statements: ALTER MATERIALIZED VIEW to ALTER SYSTEM

ALTER MATERIALIZED VIEW ........................................................................................................ 11-2

ALTER MATERIALIZED VIEW LOG ............................................................................................ 11-15

ALTER OPERATOR ........................................................................................................................... 11-21

ALTER OUTLINE ............................................................................................................................... 11-24

ALTER PACKAGE ............................................................................................................................. 11-26

ALTER PROCEDURE ........................................................................................................................ 11-29

ALTER PROFILE ................................................................................................................................ 11-32

ALTER RESOURCE COST ............................................................................................................... 11-35

ALTER ROLE ....................................................................................................................................... 11-38

ALTER ROLLBACK SEGMENT ..................................................................................................... 11-40

ALTER SEQUENCE ........................................................................................................................... 11-43

ALTER SESSION ................................................................................................................................ 11-45

Initialization Parameters and ALTER SESSION....................................................................... 11-50

Session Parameters and ALTER SESSION ............................................................................... 11-53

ALTER SYSTEM ................................................................................................................................. 11-60

Initialization Parameters and ALTER SYSTEM........................................................................ 11-72

System Parameters and ALTER SYSTEM.................................................................................. 11-83

Shared Server Parameters .................................................................................................... 11-83

12 SQL Statements: ALTER TABLE to ALTER TABLESPACE

ALTER TABLE ....................................................................................................................................... 12-2

ALTER TABLESPACE ........................................................................................................................ 12-79

13 SQL Statements: ALTER TRIGGER to COMMIT

ALTER TRIGGER ................................................................................................................................. 13-2

ALTER TYPE ......................................................................................................................................... 13-5

ALTER USER ....................................................................................................................................... 13-18

ALTER VIEW ....................................................................................................................................... 13-25

ANALYZE ............................................................................................................................................ 13-27

ASSOCIATE STATISTICS ................................................................................................................ 13-38

AUDIT .................................................................................................................................................. 13-42

CALL ..................................................................................................................................................... 13-53

COMMENT ......................................................................................................................................... 13-57

COMMIT ............................................................................................................................................. 13-59

14 SQL Statements: CREATE CLUSTER to CREATE JAVA

CREATE CLUSTER .............................................................................................................................. 14-2

CREATE CONTEXT ............................................................................................................................. 14-9

CREATE CONTROLFILE ................................................................................................................. 14-12

CREATE DATABASE ......................................................................................................................... 14-18

CREATE DATABASE LINK ............................................................................................................. 14-31

xvii

CREATE DIMENSION ..................................................................................................................... 14-36

CREATE DIRECTORY ...................................................................................................................... 14-42

CREATE DISKGROUP ..................................................................................................................... 14-44

CREATE FUNCTION ........................................................................................................................ 14-48

CREATE INDEX ................................................................................................................................. 14-58

CREATE INDEXTYPE ....................................................................................................................... 14-81

CREATE JAVA ..................................................................................................................................... 14-84

15 SQL Statements: CREATE LIBRARY to CREATE SPFILE

CREATE LIBRARY ............................................................................................................................... 15-2

CREATE MATERIALIZED VIEW ..................................................................................................... 15-4

CREATE MATERIALIZED VIEW LOG ......................................................................................... 15-25

CREATE OPERATOR ........................................................................................................................ 15-32

CREATE OUTLINE ............................................................................................................................ 15-35

CREATE PACKAGE ........................................................................................................................... 15-39

CREATE PACKAGE BODY .............................................................................................................. 15-43

CREATE PFILE .................................................................................................................................... 15-47

CREATE PROCEDURE ..................................................................................................................... 15-49

CREATE PROFILE ............................................................................................................................. 15-54

CREATE RESTORE POINT ............................................................................................................. 15-60

CREATE ROLE .................................................................................................................................... 15-63

CREATE ROLLBACK SEGMENT .................................................................................................. 15-66

CREATE SCHEMA ............................................................................................................................. 15-69

CREATE SEQUENCE ........................................................................................................................ 15-71

CREATE SPFILE ................................................................................................................................. 15-75

16 SQL Statements: CREATE SYNONYM to CREATE TRIGGER

CREATE SYNONYM ........................................................................................................................... 16-2

CREATE TABLE .................................................................................................................................... 16-6

CREATE TABLESPACE ..................................................................................................................... 16-61

CREATE TRIGGER ............................................................................................................................ 16-75

17 SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT

CREATE TYPE ....................................................................................................................................... 17-3

CREATE TYPE BODY ........................................................................................................................ 17-21

CREATE USER .................................................................................................................................... 17-26

CREATE VIEW .................................................................................................................................... 17-32

DELETE ................................................................................................................................................ 17-43

DISASSOCIATE STATISTICS ........................................................................................................ 17-51

DROP CLUSTER ................................................................................................................................ 17-53

DROP CONTEXT ............................................................................................................................... 17-55

DROP DATABASE ............................................................................................................................. 17-56

DROP DATABASE LINK ................................................................................................................. 17-57

DROP DIMENSION .......................................................................................................................... 17-58

DROP DIRECTORY .......................................................................................................................... 17-59

DROP DISKGROUP ......................................................................................................................... 17-60

xviii

DROP FUNCTION ............................................................................................................................ 17-62

DROP INDEX....................................................................................................................................... 17-64

DROP INDEXTYPE ........................................................................................................................... 17-66

DROP JAVA ......................................................................................................................................... 17-67

DROP LIBRARY ................................................................................................................................. 17-68

DROP MATERIALIZED VIEW........................................................................................................ 17-69

DROP MATERIALIZED VIEW LOG ............................................................................................. 17-71

DROP OPERATOR ............................................................................................................................ 17-73

DROP OUTLINE ................................................................................................................................ 17-74

DROP PACKAGE ............................................................................................................................... 17-75

DROP PROCEDURE ......................................................................................................................... 17-77

DROP PROFILE .................................................................................................................................. 17-78

DROP RESTORE POINT ................................................................................................................. 17-79

DROP ROLE ........................................................................................................................................ 17-80

DROP ROLLBACK SEGMENT ...................................................................................................... 17-81

SQL Statements: DROP SEQUENCE to ROLLBACK

DROP SEQUENCE .............................................................................................................................. 18-2

DROP SYNONYM ............................................................................................................................... 18-3

DROP TABLE ........................................................................................................................................ 18-5

DROP TABLESPACE ........................................................................................................................... 18-9

DROP TRIGGER................................................................................................................................. 18-12

DROP TYPE ......................................................................................................................................... 18-13

DROP TYPE BODY ............................................................................................................................ 18-15

DROP USER ........................................................................................................................................ 18-16

DROP VIEW ........................................................................................................................................ 18-18

EXPLAIN PLAN .................................................................................................................................. 18-20

FLASHBACK DATABASE ................................................................................................................ 18-23

FLASHBACK TABLE ......................................................................................................................... 18-26

GRANT ................................................................................................................................................. 18-32

INSERT ................................................................................................................................................. 18-51

LOCK TABLE ...................................................................................................................................... 18-68

MERGE ................................................................................................................................................. 18-71

NOAUDIT ............................................................................................................................................ 18-76

PURGE .................................................................................................................................................. 18-80

RENAME .............................................................................................................................................. 18-82

REVOKE ............................................................................................................................................... 18-84

ROLLBACK ......................................................................................................................................... 18-92

19 SQL Statements: SAVEPOINT to UPDATE

SAVEPOINT .......................................................................................................................................... 19-2

SELECT ................................................................................................................................................... 19-4

SET CONSTRAINT[S] ...................................................................................................................... 19-48

SET ROLE ............................................................................................................................................ 19-50

SET TRANSACTION ........................................................................................................................ 19-52

TRUNCATE ......................................................................................................................................... 19-55

xix

UPDATE ............................................................................................................................................... 19-59

A How to Read Syntax Diagrams

Graphic Syntax Diagrams...................................................................................................................... A-1

Required Keywords and Parameters ............................................................................................ A-2

Optional Keywords and Parameters ............................................................................................. A-3

Syntax Loops...................................................................................................................................... A-3

Multipart Diagrams ......................................................................................................................... A-4

Database Objects .............................................................................................................................. A-4

B Oracle and Standard SQL

ANSI Standards ...................................................................................................................................... B-1

ISO Standards .......................................................................................................................................... B-2

Oracle Compliance To Core SQL:2003................................................................................................. B-3

Oracle Support for Optional Features of SQL/Foundation:2003.................................................... B-8

Oracle Compliance with SQL/CLI:2003 ............................................................................................ B-15

Oracle Compliance with SQL/PSM:2003 .......................................................................................... B-15

Oracle Compliance with SQL/MED:2003 ......................................................................................... B-15

Oracle Compliance with SQL/XML:2005.......................................................................................... B-16

Oracle Compliance with FIPS 127-2 ................................................................................................. B-22

Oracle Extensions to Standard SQL .................................................................................................. B-24

Character Set Support........................................................................................................................... B-24

C Oracle Regular Expression Support

Multilingual Regular Expression Syntax .......................................................................................... C-1

Regular Expression Operator Multilingual Enhancements............................................................ C-2

Perl-influenced Extensions in Oracle Regular Expressions ........................................................... C-3

D Oracle Database Reserved Words

E Examples

Using Extensible Indexing ................................................................................................................... E-1

Using XML in SQL Statements ............................................................................................................ E-8

Index

剩余1427页未读，继续阅读

纳兰瑞雪

粉丝: 51
资源: 39

Oracle 10g Release 2 (10.2) SQL Reference Manual B14200-02: Dec ...

最新资源

Oracle 10g Release 2 (10.2) SQL Reference Manual B14200-02: Dec ...

Oracle Database Reference 10g Release 2(10.2)

Oracle Database Concepts 10g Release 2 (10.2).pdf

Oracle Database 2 Day DBA 10g Release 2 (10.2)

Oracle Database Administrators Guide 10g Release 2 (10.2).pdf

Oracle Database Readme 11gRelease2(11.2)-225

Oracle Database Utilities 11gRelease2(11.2)-746

Oracle Database Release Notes 11g Release 2 (11.2) for Linux-34.

OracleDatabaseSQLReference10gRelease2.pdf 英文原版

Oracle10gRelease安装手册.docx

Oracle Database New Features Guide 11gRelease2(11.2)

最新资源