目次

1      前書き

1.1   新着情報

1.2   このガイドで使用される表記規則

2      SQL言語

2.1   SQL構文

2.1.1  Lexical Structure

2.1.2  Identifiers and Key Words

2.1.3  Constants

2.1.4  Comments

2.2   データ型

2.2.1  Numeric Types

2.2.2  Character Types

2.2.3  Binary Data

2.2.4  Date/Time Types

2.2.5  Boolean Type

2.2.6  XML Type

2.3   SQLコマンド

2.3.1  ALTER INDEX

2.3.2  ALTER PROCEDURE

2.3.3  ALTER PROFILE

2.3.4  ALTER QUEUE

2.3.5  ALTER QUEUE TABLE

2.3.6  ALTER ROLE… IDENTIFIED BY

2.3.7  ALTER ROLE - Managing Database Link and DBMS_RLS Privileges

2.3.8  ALTER SEQUENCE

2.3.9  ALTER SESSION

2.3.10 ALTER TABLE

2.3.11 ALTER TABLESPACE

2.3.12 ALTER USER… IDENTIFIED BY

2.3.13 ALTER USER|ROLE… PROFILE MANAGEMENT CLAUSES

2.3.14 CALL

2.3.15 COMMENT

2.3.16 COMMIT

2.3.17 CREATE DATABASE

2.3.18 CREATE [PUBLIC] DATABASE LINK

2.3.19 CREATE DIRECTORY

2.3.20 CREATE FUNCTION

2.3.21 CREATE INDEX

2.3.22 CREATE MATERIALIZED VIEW

2.3.23 CREATE PACKAGE

2.3.24 CREATE PACKAGE BODY

2.3.25 CREATE PROCEDURE

2.3.26 CREATE PROFILE

2.3.27 CREATE QUEUE

2.3.28 CREATE QUEUE TABLE

2.3.29 CREATE ROLE

2.3.30 CREATE SCHEMA

2.3.31 CREATE SEQUENCE

2.3.32 CREATE SYNONYM

2.3.33 CREATE TABLE

2.3.34 CREATE TABLE AS

2.3.35 CREATE TRIGGER

2.3.36 CREATE TYPE

2.3.37 CREATE TYPE BODY

2.3.38 CREATE USER

2.3.39 CREATE USER|ROLE… PROFILE MANAGEMENT CLAUSES

2.3.40 CREATE VIEW

2.3.41 DELETE

2.3.42 DROP DATABASE LINK

2.3.43 DROP DIRECTORY

2.3.44 DROP FUNCTION

2.3.45 DROP INDEX

2.3.46 DROP PACKAGE

2.3.47 DROP PROCEDURE

2.3.48 DROP PROFILE

2.3.49 DROP QUEUE

2.3.50 DROP QUEUE TABLE

2.3.51 DROP SYNONYM

2.3.52 DROP ROLE

2.3.53 DROP SEQUENCE

2.3.54 DROP TABLE

2.3.55 DROP TABLESPACE

2.3.56 DROP TRIGGER

2.3.57 DROP TYPE

2.3.58 DROP USER

2.3.59 DROP VIEW

2.3.60 EXEC

2.3.61 GRANT

2.3.62 GRANT on Database Objects

2.3.63 GRANT on Roles

2.3.64 GRANT on System Privileges

2.3.65 INSERT

2.3.66 LOCK

2.3.67 REVOKE

2.3.68 ROLLBACK

2.3.69 ROLLBACK TO SAVEPOINT

2.3.70 SAVEPOINT

2.3.71 SELECT

2.3.72 SET CONSTRAINTS

2.3.73 SET ROLE

2.3.74 SET TRANSACTION

2.3.75 TRUNCATE

2.3.76 UPDATE

2.4   関数と演算子

2.4.1  Logical Operators

2.4.2  Comparison Operators

2.4.3  Mathematical Functions and Operators

2.4.4  String Functions and Operators

2.4.5  Pattern Matching String Functions

2.4.6  Pattern Matching Using the LIKE Operator

2.4.7  Data Type Formatting Functions

2.4.8  Date/Time Functions and Operators

2.4.9  Sequence Manipulation Functions

2.4.10 Conditional Expressions

2.4.11 Aggregate Functions

2.4.12 Subquery Expressions

3      Oracleカタログ・ビュー

3.1   ALL_ALL_TABLES

3.2   ALL_CONS_COLUMNS

3.3   ALL_CONSTRAINTS

3.4   ALL_DB_LINKS

3.5   ALL_DIRECTORIES

3.6   ALL_IND_COLUMNS

3.7   ALL_INDEXES

3.8   ALL_JOBS

3.9   ALL_OBJECTS

3.10 ALL_PART_KEY_COLUMNS

3.11 ALL_PART_TABLES

3.12 すべてのポリシー

3.13 ALL_QUEUES

3.14 ALL_QUEUE_TABLES

3.15 ALL_SEQUENCES

3.16 ALL_SOURCE

3.17 ALL_SUBPART_KEY_COLUMNS

3.18 ALL_SYNONYMS

3.19 ALL_TAB_COLUMNS

3.20 ALL_TAB_PARTITIONS

3.21 ALL_TAB_SUBPARTITIONS

3.22 ALL_TABLES

3.23 ALL_TRIGGERS

3.24 AL L_TYPES

3.25 全てのユーザー

3.26 ALL_VIEW_COLUMNS

3.27 ALL_VIEWS

3.28 DBA_ALL_TABLES

3.29 DBA_CONS_COLUMNS

3.30 DBA_CONSTRAINTS

3.31 DBA_DB_LINKS

3.32 DBA_DIRECTORIES

3.33 DBA_IND_COLUMNS

3.34 DBA_INDEXES

3.35 DB A_JOBS

3.36 DBA_OBJECTS

3.37 DBA_PART_KEY_COLUMNS

3.38 DBA_PART_TABLES

3.39 DBA_POLICIES

3.40 DBA_PROFILES

3.41 DBA_QUEUES

3.42 DBA_QUEUE_TABLES

3.43 DBA_ROLE_PRIVS

3.44 DBA_ROLES

3.45 DBA_SEQUENCES

3.46 DBA_SOURCE

3.47 DBA_SUBPART_KEY_COLUMNS

3.48 DBA_SYNONYMS

3.49 DBA_TAB_COLUMNS

3.50 DBA_TAB_PARTITIONS

3.51 DBA_TAB_SUBPARTITIONS

3.52 DBA_TABLES

3.53 DBA_TRIGGERS

3.54 DB A_TYPES

3.55 DBA_USERS

3.56 DBA_VIEW_COLUMNS

3.57 DBA_VIEWS

3.58 USER_ALL_TABLES

3.59 USER_CONS_COLUMNS

3.60 USER_CONSTRAINTS

3.61 USER_DB_LINKS

3.62 USER_IND_COLUMNS

3.63 USER_INDEXES

3.64 米国 ER_JOBS

3.65 USER_OBJECTS

3.66 USER_PART_KEY_COLUMNS

3.67 USER_PART_TABLES

3.68 USER_POLICIES

3.69 USER_QUEUES

3.70 USER_QUEUE_TABLES

3.71 USER_ROLE_PRIVS

3.72 USER_SEQUENCES

3.73 USER_SOURCE

3.74 USER_SUBPART_KEY_COLUMNS

3.75 USER_SYNONYMS

3.76 USER_TAB_COLUMNS

3.77 USER_TAB_PARTITIONS

3.78 USER_TAB_SUBPARTITIONS

3.79 USER_TABLES

3.80 USER_TRIGGERS

3.81 USER_TYPES

3.82 USER_USERS

3.83 USER_VIEW_COLUMNS

3.84 USER_VIEWS

3.85 V $ VERSION

3.86 PRODUCT_COMPONENT_VERSION

4      システムカタログテーブル

4.1   デュアル

4.2   edb_dir

4.3   edb_password_history

4.4   edb_policy

4.5   edb_profile

4.6   edb_variable

4.7   pg_synonym

4.8   product_component_version

5      謝辞