oracle 10g 相关语法

1.新建聚簇
CREATE CLUSTER [schema.]cluster
    (column datatype [,column datatype] )
    [PCTUSED integer]
    [PCTFREE integer]
    [INITRANS integer]
    [maxtrans integer]
    [SIZE integer [K|M] ]
    [TABLESPACE tablespace]
    [STORAGE storage_clause]
    [ INDEX
      | HASHKEYS integer [ HASH IS expr]
    [PARALLEL parallel_clause] [CACHE | NOCACHE]
2.新建控制文件
CREATE CONTROLFILE [REUSE]
    [SET] DATABASE database
    LOGFILE [GROUP integer] filespec [, [GROUP integer] filespec]
    {RESETLOGS | NORESETLOGS}
    DATAFILE filespec [, filespec]
    [MAXLOGFILES integer]
    [MAXLOGMEMBERS integer]
    [MAXLOGHISTORY integer]
    [MAXDATAFILES integer]
    [MAXINSTANCES integer]
    [ARCHIVELOG | NOARCHIVELOG]

3.新建数据库
CREATE DATABASE [database]
    [CONTROLFILE REUSE]
    [LOGFILE [GROUP integer] filespec [, [GROUP integer] filespec] ]
    [MAXLOGFILES integer ]
    [MAXLOGMEMBERS integer]
    [MAXLOGHISTORY integer]
    [MAXDATAFILES integer]
    [MAXINSTANCES integer]
    [ARCHIVELOG | NOARCHIVELOG}
    [EXCLUSIVE]
    [CHARACTER SET charset]
    [DATAFILE filespec [AUTOEXTEND { OFF
                                   | ON [ NEXT integer [K|M]
                                        | MAXSIZE {UNLIMITED | integer [K|M] }
                       [ [, filespec] [AUTOEXTEND { OFF
                                                  | ON [ NEXT integer [K|M]
                                                       | MAXSIZE {UNLIMITED | integer [K|M] }] ]

4.新建数据库连接（远程连接到其他数据库）
CREATE [PUBLIC] DATABASE LINK dblink
    [CONNECT TO user IDENTIFIED BY password]
    [USING 'onnect_string']

5.新建函数
CREATE [OR REPLACE] FUNCTION [schema.]function
    [ (argument [IN] datatype
    [, argument [IN] datatype] )]
    RETURN datatype
    {IS | AS} pl/sql_subprogram_body

6.新建索引
CREATE [UNIQUE] INDEX [schema.]index
    ON { [schema.]table (column [ASC|DESC][, column [ASC|DESC]] )
        | CLUSTER [schema.]cluster }
    [INITRANS integer]
    [MAXTRANS integer]
    [TABLESPACE tablespace]
    [STORAGE storage_clause]
    [PCTFREE integer]
    [NOSORT]
    [ { RECOVERABLE | UNRECOVERABLE}]
    [PARALLEL parallel_clause]

7.新建图视
CREATE MATERIALIZED VIEW [schema.]materialized_view
    [ [PCTFREE  integer] [PCTUSED  integer]
      [INITRANS integer] [MAXTRANS integer]
      [TABLESPACE tablespace]
      [STORAGE storage_clause]
    [ USING INDEX [  PCTFREE integer | TABLESPACE tablespace
                    | INITTRANS integer | MAXTRANS integer
                    | STORAGE storage_clause ]
    | USING NO INDEX
    | [CLUSTER cluster (column [, column])] ]
    [ REFRESH [FAST | COMPLETE | FORCE] [ON {DEMAND | COMMIT}] [START WITH date] [NEXT date]]
    AS subquery

8.新建包
CREATE [OR REPLACE] PACKAGE [schema.]package
    {IS | AS} pl/sql_package_body

9.新建包体
CREATE [OR REPLACE] PACKAGE BODY [schema.]package
    {IS | AS} pl/sql_package_body

10.新建存储过程
CREATE [OR REPLACE] PROCEDURE [schema.]procedure
    [ (argument [IN | OUT | IN OUT] datatype
    [, argument [IN | OUT | IN OUT] datatype] )]
    {IS | AS} pl/sql_subprogram_body

11.新建配置文件
CREATE PROFILE profile
    LIMIT [SESSIONS_PER_USER  {integer | UNLIMITED | DEFAULT}]
        [CPU_PER_SESSION  {integer | UNLIMITED | DEFAULT}]
        [CPU_PER_CALL  {integer | UNLIMITED | DEFAULT}]
        [CONNECT_TIME  {integer | UNLIMITED | DEFAULT}]
        [IDLE_TIME  {integer | UNLIMITED | DEFAULT}]
        [LOGICAL_READS_PER_SESSIONS {integer | UNLIMITED | DEFAULT}]
        [LOGICAL_READS_PER_CALL {integer | UNLIMITED | DEFAULT}]
        [COMPOSITE_LIMIT {integer | UNLIMITED | DEFAULT}]
        [PRIVATE_SGA {integer  [K|M]| UNLIMITED | DEFAULT}]

12.新建角色
CREATE ROLE role
    [ NOT IDENTIFIED
    | IDENTIFIED {BY password |EXTERNALLY} ]

13.新建回滚
CREATE [PUBLIC] ROLLBACK SEGMENT rollback_segment
    [TABLESPACE tablespace]
    [STORAGE storage_clause]
14.新建数据模式
CREATE SCHEMA AUTHORIZATION schema
    { CREATE TABLE command
    | CREATE VIEW command
    | GRANT command
15.新建序列号
CREATE SEQUENCE [schema.]sequence
    [INCREMENT by integer]
    [START with integer]
    [MAXVALUE integer | NOMAXVALUE]
    [MINVALUE integer | NOMINVALUE]
    [CYCLE | NOCYCLE]
    [CACHE integer | NOCACHE]
    [ORDER |NOORDER]

16.新建快照
CREATE SNAPSHOT [schema.]snapshot
    [ [PCTFREE  integer] [PCTUSED integer]
      [INITRANS integer] [MAXTRANS integer]
      [TABLESPACE tablespace]
      [STORAGE storage_clause]
    | [CLUSTER cluster (column [, column])] ]
    [ REFRESH [FAST | COMPLETE | FORCE] [START WITH date] [NEXT date] ]
    AS subquery

17.新建快照日志
CREATE SNAPSHOT LOG ON [schema.]table
    [PCTFREE  integer]  [PCTUSED integer]
    [INITRANS integer]  [MAXTRANS integer]
    [TABLESPACE tablespace]
    [STORAGE storage_clause]
18.新建同义词
CREATE [PUBLIC] SYNONYM [schema.]synonym
    FOR [schema.]object[@dblink]
19.新建表
CREATE TABLE [schema.]table
    ( { column datatype [DEFAULT expr] [column_constraint]
      |table_constraint}
  [,  { column datatype [DEFAULT expr] [column_constraint]
      |table_constraint} ] )
  [   [PCTFREE  integer] [PCTUSED integer]
      [INITRANS integer] [MAXTRANS integer]
      [TABLESPACE tablespace]
      [STORAGE storage_clause]
      [ {RECOVERABLE | UNRECOVERABLE}
  |  [CLUSTER cluster (column [, column])] ]
  [ PARALLEL parallel_clause]
  [  ENABLE enable_clause
  |  DISABLE disable_clause ]
  [AS subquery]
  [CACHE]
  [NOCACHE]
20.新建表空间
CREATE TABLESPACE tablespace
    DATAFILE filespec [AUTOEXTEND {OFF | ON [ NEXT integer [K|M]
                                            | MAXSIZE {UNLIMITED | integer [K|M] } ]
                      [, filespec [AUTOEXTEND {OFF | ON [ NEXT integer [K|M]
                                                   | MAXSIZE {UNLIMITED | integer [K|M] } ] ]
    [DEFAULT STORAGE storage_clause]
    [ONLINE | OFFLINE]
    [PERMANENT | TEMPORARY]
21.新建触发器
CREATE [OR REPLACE] TRIGGER [schema.]trigger
    {BEFORE | AFTER}
    {DELETE | INSERT | UPDATE [OF column [, column] ]}
    [OR{DELETE | INSERT | UPDATE [OF column [, column] ]}]
    ON [schema.]table
    [ [REFERENCING { OLD [AS] old [NEW [AS] new]
                | NEW [AS] new [OLD [AS] old] } ]
    FOR EACH ROW
    [WHEN (condition)] ]
    pl/sql_block
22.新建数据类型
CREATE [OR REPLACE] TYPE [schema.]type_name
    [OID object_identifier]
    {IS|AS} {VARRAY | VARYING ARRAY} (limit) OF datatype
    | [AUTHID {CURRENT_USER | DEFINER}]
      {{IS|AS} OBJECT
       | UNDER [schema.]supertype
      }
      [EXTERNAL NAME java_ext_name LANGUAGE JAVA USING (SQLData | CustomDatum | OraData)]
      [({ attribute datatype [EXTERNAL NAME field_name]}
          [,
           [{[NOT]{ OVERRIDING | FINAL | INSTANTIABLE}}]
           { {MEMBER | STATIC} {procedure_spec | function_spec}
             | [FINAL] [INSTANTIABLE]
                 CONSTRUCTOR FUNCTION datatype
                 [ ([SELF IN OUT datatype, ]
                    parameter datatype[, parameter datatype ]
                   )
                 ]
                 RETURN SELF AS RESULT
                 [ {IS|AS} call_spec]
             | {MAP | ORDER} MEMBER function_spec
           }[, PRAGMA RESTRICT_REFERENCES
               ({method_name | DEFAULT} ,
                { RNDS | WNDS |RNPS |WNPS | TRUST }
                  [, { RNDS | WNDS |RNPS |WNPS | TRUST }]
               )
            ]
          ]
       )
      ]
23.新建用户名
CREATE USER user
    IDENTIFIED {BY password | EXTERNALLY}
    [DEFAULT TABLESPACE tablespace]
    [TEMPORATRY TABLESPACE tablespace]
    [QUOTA {integer [K|M] | UNLIMITED} on tablespace]
    [PROFILE profile]
24.新建视图
CREATE [OR REPLACE] [FORCE | NOFORCE] VIEW [schema.]view
    [(alias [,alias] )]
    AS subquery
    [WITH CHECK OPTION [CONSTRAINT constraint]]

--修改
25.修改聚簇
ALTER CLUSTER [schema.]cluster
    [PCTUSED integer]
    [PCTFREE integer]
    [SIZE integer [K|M] ]
    [INITRANS integer]
    [MAXTRANS integer]
    [STORAGE storage_clause]
    [ALLOCATE EXTENT ( SIZE integer [K|M] | DATAFILE 'filename' | INSTANCE integer ) ]
    [DEALLOCATE UNUSED [KEEP integer [K|M] ] ]
    [PARALLEL parallel_clause]
26.修改数据库
ALTER DATABASE [database]
    {MOUNT [STANDBY DATABASE] [EXCLUSIVE | PARALLEL]
    | CONVERT
    | OPEN [RESETLOGS | NORESETLOGS]
    | ACTIVATE STANDBY DATABASE
    | ARCHIVELOG
    | NOARCHIVELOG
    | RECOVER recover_clause
    | ADD LOGFILE [THREAD integer] [GROUP integer] filespec
                                   [, [GROUP integer] filespec]
    | ADD LOGFILE MEMBER 'FILENAME'[REUSE] [, 'FILENAME'[REUSE]]
          TO { GROUP integer
             | ('filename'[,'filename'] )
             |  'filename'}
                                [,'filename'[REUSE] [, 'filename'[REUSE]]
                                | ('filename'[,'filename'] )
                                |  'filename'} ]
    | DROP LOGFILE { GROUP integer
                           | ('filename'[,'filename'] )
                           |  'filename'}
    [,GROUP integer
                                | ('filename'[,'filename'] )
                                |  'filename'} ]
    | DROP LOGFILE MEMBER filename'[, FILENAME']
    | CLEAR [UNARCHIVED] LOGFILE { GROUP integer
                           | ('filename'[,'filename'] )
                           |  'filename'}
    [,GROUP integer
                                | ('filename'[,'filename'] )
                                |  filename'} ]
                           [UNRECOVERABLE DATAFILE]
    | RENAME FILE 'filename'[,'filename']
             TO filename[, 'filename']
    | CREATE STANDBY CONTROLFILE AS 'filename' [REUSE]
    | BACKUP CONTROLFILE { TO 'filename'[REUSE] | TO TRACE [RESETLOGS | NORESETLOGS] }
    | CREATE DATAFILE filename[, filename]
             [AS filespec [, filespec]
    | DATAFILE filename{ ONLINE
                          | OFFLINE [DROP]
                          | RESIZE integer [K|M]
                          | AUTOEXTEND [ OFF
                                       | ON [ NEXT integer [K|M]
                                            | MAXSIZE UNLIMITED | integer [K|M]}
                          | END BACKUP
    | ENABLE [PUBLIC] THREAD integer
    | DISABLE THREAD integer
    | RENAME GLOBAL_NAME TO database[.domain]
    | SET { DBMAC {ON | OFF}
          | DBHIGH = 'text'          | DBLOW  = text} }

27.修改函数
 ALTER FUNCTION [schema.]function COMPILE
28.修改索引
ALTER INDEX [schema.]index
    [PCTFREE integer]
    [INITRANS integer]
    [MAXTRANS integer]
    [STORAGE storage_clause]
    [ALLOCATE EXTENT [ ( SIZE integer[K|M]
                       | DATAFILE 'filename'
                       | INSTANCE integer ) ]
    [DEALLOCATE UNUSED [KEEP integer [K|M] ]
    [REBUILD [ {PARALLEL integer | NOPARALLEL}
             | {RECOVERABLE | UNRECOVERABLE }
             | TABLESPACE tablespace ]
29.修改包
 ALTER PACKAGE [schema.]package
    COMPILE [PACKAGE | BODY]

30.修改存储过程
 ALTER PROCEDURE [schema.]procedure
    COMPILE
31.修改配置
ALTER PROFILE profile
    LIMIT    [SESSIONS_PER_USER {integer | UNLIMITED | DEFAULT}]
             [CPU_PER_SESSION {integer | UNLIMITED | DEFAULT}]
             [CPU_PER_CALL {integer | UNLIMITED | DEFAULT}]
             [CONNECT_TIME {integer | UNLIMITED | DEFAULT}]
             [IDLE_TIME  {integer | UNLIMITED | DEFAULT}]
             [LOGICAL_READS_PER_SESSION {integer | UNLIMITED | DEFAULT}]
             [LOGICAL_READS_PER_CALL {integer | UNLIMITED | DEFAULT}]
             [COMPOSITE_LIMIT {integer | UNLIMITED | DEFAULT}]
             [PRIVATE_SGA {integer  [K|M]    | UNLIMITED | DEFAULT}]
32.修改计算Oracle SQL会话成本语法
ALTER RESOURCE
    COST     [CPU_PER_SESSION  integer]
             [CONNECT_TIME  integer]
             [LOGICAL_READS_PER_SESSION integer]
             [PRIVATE_SGA  integer]
33.修改角色
ALTER ROLE role
    { NOT IDENTIFIED
    | IDENTIFIED {BY password | EXTERNALLY}
34.修改回滚
ALTER ROLLBACK SEGMENT rollback_segment
    { ONLINE
    | OFFLINE
    | STORAGE storage_clause
    | SHRINK [TO integer [K|M] ] }
35.修改产生序列
ALTER SEQUENCE [schema.]sequences
    [INCREMENT BY integer
    [MAXVALUE integer | NOMAXVALUE]
    [MINVALUE integer | NOMINVALUE]
    [CYCLE | NOCYCLE]
    [CACHE integer | NOCACHE]
    [ORDER |NOORDER]
36.修改会话
ALTER SESSION
    { SET  { SQL_TRACE  = { TRUE | FALSE }
        | GLOBAL_NAMES  = { TRUE | FALSE }
        | NLS_LANGUAGE  =   language
        | NLS_TERRITORY  =   territory
        | NLS_DATE_FORMAT =  'fmt'        | NLS_DATE_LANGUAGE =   language
        | NLS_NUMBERIC_CHARACTERS =  'text'        | NLS_ISO_CURRENCY =   territory
        | NLS_CURRENCY  =  'text'        | NLS_SORT  = { sort | BINARY }
        | NLS_CALENDAR          = 'text'
        | LABEL  = {'text' DBHIGH |DBLOW | OSLABEL }
        | MLS_LABEL_FORMAT      = 'fmt'        | OPTIMIZER_GOAL        = { RULE|ALL_ROWS|FIRST_ROWS|CHOOSE}
        | FLAGGER               = {ENTRY|INTERMEDIATE|FULL|OFF}
        | SESSION_CACHED_CURSORS= integer
        | CLOSE_CACHED_OPEN_CURSORS = {TRUE | FALSE}
        | INSTANCE = integer
        | HASH_JOIN_ENABLED     = {TRUE | FALSE}
        | HASH_AREA_SIZE        = integer
        | HASH_MULTIBLOCK_IO_COUNT = integer
        | REMOTE_DEPENDENCIES_MODE = {TIMESTAMP | SIGNATURE}
        | ISOLATION_LEVEL       = {SERIALIZABLE | READ COMMITTED}
    }  
    | CLOSE DATABASE LINK dblink
    |ADVISE {COMMIT | ROLLBACK | NOTHING }
    | {ENABLE | DISABLE } COMMIT IN PROCEDURE }
37.修改快照
ALTER SNAPSHOT [schema.]snapshot
    [ PCTFREE  integer  | PCTUSED integer
    | INITRANS integer  | MAXTRANS integer
    | STORAGE storage_clause ]
    [REFRESH [FAST | COMPLETE | FORCE] [START WITH date] [NEXT date]]
38.修改快照日志
ALTER SNAPSHOT LOG ON [schema.]table
    [PCTFREE  integer]  [PCTUSED  integer]
    [INITRANS integer]  [MAXTRANS integer]
    [STORAGE storage_clause]
39.修改系统参数
ALTER SYSTEM
    {  {ENABLE | DISABLE} RESTRICTED SESSION
    | FLUSH SHARED_POOL
    | {CHECKPOINT | CHECK DATAFILES} [ GLOBAL | LOCAL]
    | SET  { RESOURCE_LIMIT   = { TRUE | FALSE}
        | global_names   = { TRUE | FALSE}
        | MTS_DISPATCHERS  = 'protocol, integer'        | MTS_SERVERS   = integer
        | LICENSE_MAX_SESSIONS  = integer
        | LICENSE_SESSIONS_WARNING = integer
        | LICENSE_MAX_USERS  = integer }
    | SWITCH LOGFILE
    | {ENABLE | DISABLE} DISRIBUTED RECOVERY
    | ARCHIVE LOG archive_log_clause
    | KILL SESSION 'integer1, integer2'}
40.修改表
ALTER TABLE [schema.]table
    [ADD  { ( column datatype [DEFAULT expr]  [column_constraint]
            | table_constraint [,
              ( column datatype [DEFAULT expr]  [column_constraint]
              | table_constraint ]) } ]
    [MODIFY { (column [datatype] [DEFAULT expr] [column_constraint][,
               column [datatype] [DEFAULT expr] [column_constraint] ]) } ]
    [PCTFREE  integer]  [pctused  integer]
    [INITRANS integer]  [maxtrans integer]
    [STORAGE storage_clause]
    [DROP drop_clause]
    [ALLOCATE EXTENT [( [SIZE integer [K|M] ]
                [DATAFILE 'filename'
                [INSTANCE integer] )]
    [ DEALLOCATE UNUSED [KEEP integer[K|M] ]
    [ ENABLE {enable_clause | TABLE LOCK}
    [ DISABLE {disable_clause | TABLE LOCK} ]
    [ [PARALLEL parallel_clause] {NOCACHE | CACHE} ]

41.修改表空间
ALTER TABLESPACE tablespace
    { ADD DATAFILE filespec [AUTOEXTEND {OFF
                                         ON [NEXT integer [K|M]
                                            | MAXSIZE {UNLIMITED | integer [K|M]} ]
                            [, filespec]
    |RENAME DATAFILE 'filename'[,'filename']
            to   'filename'[,'filename']
    |COALESCE
    |DEFAULT STORAGE storage_clause
    |ONLINE
    |OFFLINE [NORMAL | TEMPORARY | IMMEDIATE]
    | {BEGIN | END} BACKUP}
    | READ {ONLY | WRITE}
    | PERMANENT
    | TEMPORARY

42.修改触发器
ALTER TRIGGER [schema.]trigger
    { ENABLE
    | DISABLE
    | COMPILE}

43.修改用户
ALTER USER user
    [IDENTIFIED {BY PASSWORD |externally}]
    [DEFAULT TABLESPACE tablespace]
    [TEMPORARY TABLESPACE tablespace]
    [QUOTA {integer [K|M] | UNLIMITED} ON tablespace]
    [PROFILE profile]
    [DEFAULT role { role [, role]
                | ALL [EXCEPT role [, role] ]
                | NONE}]
44.修改视图
ALTER VIEW [schema.]view
    COMPILE

45.删除主键
DROP { PRIMARY KEY
        | UNIQUE (column [, column] )
        | CONSTRAINT constraint }
        [CASCADE]
46.删除聚簇
DROP CLUSTER [schema.]cluster
    [INCLUDING TABLES [CASCADE CONSTRAINTS] ]
47.删除数据库连接
DROP [PUBLIC] DATABASE LINK dblink
48.删除函数
DROP FUNCTION [schema.]function
49.删除索引
DROP INDEX [schema.]index
50.删除包体
DROP PACKAGE [BODY] [schema.]package
51.删除存储过程
DROP PROCEDURE [schema.]procedure
52.删除配置文件
DROP PROFILE profile
    [CASCADE]
53.删除角色
DROP ROLE role
54.删除回滚
DROP ROLLBACK SEGMENT rollback_segment
55.删除序列
DROP SEQUENCE [schema.]sequence
56.删除快照
DROP SNAPSHOT [schema.]snapshot
57.删除快照日志
DROP SNAPSHOT LOG ON [schema.]table
58.删除同义词
DROP [PUBLIC] SYNONYM [schema.]synonym
59.删除表
DROP TABLE [schema.]table
    [CASCADE CONSTRAINTS]
60.删除表空间
DROP TABLESPACE tablespace
    [INCLUDING CONTENTS [CASCADE CONSTRAINTS]]
61.删除触发器
DROP TRIGGER [schema.]trigger
62.删除用户
DROP USER user [CASCADE]
63.删除视图
DROP VIEW [schema.]view
64.数据查询
SELECT [DISTINCT | ALL] { *
                        | { [schema.]{table | view | snapshot}. *
                          | expr [AS] [c_alias] }
                        [,{ [schema.]{table | view | snapshot}. *
                          | expr [AS} [c_alias] } ]  }
    FROM { [schema.]{table | view | snapshot}[@dblink] | ( subquery ) } [t_alias]
         { [, [schema.]{table | view | snapshot}[@dblink] | ( subquery ) } [t_alias] ]
    [WHERE condition ]
    [ [START WITH condition] CONNECT BY condition]
    [GROUP BY expr [, expr]  [HAVING condition] ]
    [{UNION | UNION ALL | INTERSECT | MINUS} SELECT command ]
    [ORDER BY {expr|position|c_alias} [ASC | DESC]
            [,  {expr|position|c_alias} [ASC | DESC]] ]
    [FOR UPDATE [OF [[schema.]{table | view}.]column
                  [,   [[schema.]{table | view}.]column]] [NOWAIT] ]

65.数据更新
UPDATE { [schema.]{table | view}[@dblink] | ( subquery_1 ) [t_alias]
    SET { (column [, column] ) = (subquery_2)
           | column = { expr | (subquery_3) } }
        [, { (column [, column] ) = (subquery_2)
           | column = { expr | (subquery_3) } } ]
    [ WHERE condition]
66.数据删除
DELETE [FROM] [schema.]{table | view}[@dblink] [alias]
    [WHERE condition]
67.插入数据
INSERT INTO { [schema.]{table |view} [@dblink] | ( subquery_1 ) }
    [ (column [, column] ) ]
    {VALUES (expr [, expr] ) | subquery_2}
68.使什么有效
ENABLE { {UNIQUE (column [, column] )
            |PRIMARY KEY
            |CONSTRAINT constraint}
                [USING INDEX [INITRANS integer]
                        [MAXTRANS integer]
                        [TABLESPACE tablespace]
                        [STORAGE storage_clause]
                        [PCTFREE integer] ]
                [EXCEPTIONS INTO [schema.]table ]
        | ALL TRIGGERS }
69.执行计划
EXPLAIN PLAN
    [SET STATEMENT ID= 'text'
    [INTO [schema.]table[@dblink]]
    FOR statement
Expr=Expr

Form 1

{ [[schema.]{table | view | snapshot} .] {column|pseudo-column|ROWLABEL}
| 'text'| numer
| sequence.{CURRVAL | NEXTVAL}
| NULL}

Form II

:host_variable [ [INDICATOR] :indicator_variable]

Form III

function_name [( [DISTINCT | ALL] expr [, expr] )]

Form IV

{ (expr) | +expr |-expr | PRIOR expr
| expr * expr | expr / expr
| expr + expr | expr - expr || expr }

Decode_expr

DECODE( expr, search, result [, search, result]  [, default] )

Expr_list

(expr [, expr] )
EXEC SQL [FOR :host_integer]
    FETCH cursor
        { INTO :host_variable [[indicator] :indicator_variable]
            [, :host_variable [[indicator] :indicator_variable] }
        | USING DESCRIPTOR descriptor

70.redo重做日志
filespec

Data files:

[filename][SIZE integer [K|M] ] [REUSE]

Redo log file groups:

{  'filename'| ('filename'[, 'filename'] )]
        [SIZE integer [K|M] ] [REUSE]

71.授权
GRANT {system_priv | role} [, {system_priv | role}]
    TO {user |role | PUBLIC} [, {user | role | PUBLIC}]
    [WITH ADMIN OPTION]

GRANT {object_priv | ALL [PRIVELEGES]} [ (column [, column] ) ]
    [, {object_priv | ALL [PRIVELEGES]} [ (column [, column] ) ] ]
        ON [schema.]object
        TO {user | role | |PUBLIC} [, {user | role |PUBLIC}]
        [WITH GRANT OPTION]

72.锁表
LOCK TABLE[schema.]{table | view}[@dblink]
            [, [schema.]{table |view}[@dblink]
        IN lockmode MODE
        [NOWAIT]
73.关闭审计项
NOAUDIT {statement_opt | system_priv}
    [,   {statement_opt | system_priv} ]
          [BY user [, user] ]
          [WHENEVER [NOT] SUCCESSFUL]

NOAUDIT object_opt [, object_opt]
        ON [schema.]object
        [WHENEVER [NOT] SUCCESSFUL]
[+|-]{digit[digit[digit][.][digit]
        |.digit[digit]}[{e|E}[+|-]digit[digit]]

74.关闭并行服务器
{ NOPARALLEL
         | PARALLEL ( { DEGREE {integer | DEFAULT}
                      | INSTANCES {integer | DEFAULT}
                      [ { DEGREE {integer | DEFAULT}
                      | INSTANCES {integer | DEFAULT} ] )
75.恢复，将还原的文件同步
RECOVER [AUTOMATIC] [FROM 憀ocation抅
        { [DATABASE] [ UNTIL CANCEL
                    | UNTIL TIME date
                    | UNTIL CHANGE integer
                    | USING BACKUP CONTROLFILE ]
            | TABLESPACE tablespace [, tablespace]
            | DATAFILE 'filename'[, 'filename']
            | LOGFILE 'filename'            | CONTINUE [default]
            | CANCEL }
76.重命名
RENAME old TO new
77.回收权限
REVOKE {system_priv | role} [, {system_priv | role}]
    FROM {user | role | PUBLIC } [, {user | role |PUBLIC}]
REVOKE {object_priv | ALL [PRIVELEGES]}
    [,  {object_priv | ALL [PRIVILEGES]}
    ON [schema.]object
    FROM {user | role | PUBLIC} [, {user | role | PUBLIC}]
    [CASCADE CONSTRAINTS]
78.回滚到某一回滚点
ROLLBACK [WORK]
    [ TO [SAVEPOINT] savepoint
    | FORCE 'text']
79.保存回滚点
SAVEPOINT savepoint
80.设置角色
SET ROLE { role [IDENTIFIED BY password]
            [, role [IDENTIFIED BY password] ]
             | ALL [EXCEPT role [, role] ]
             | NONE }
81.设置数据事务
SET TRANSACTION
    { READ ONLY
    | READ WRITE
    | ISOLATION LEVEL [ SERIALIZABLE | READ COMMITTED ]
    | USE ROLLBACK SEGMENT rollback_segment }
82.全文索引的STORAGE属性
STORAGE { [INITIAL  integer [K|M] ]
                  [NEXT                 integer [K|M] ]
                  [MINEXTENTS  integer ]
                  [MAXEXTENTS  {integer | UNLIMITED} ]
                  [PCTINCREASE  integer [K|M] ]
                  [FREELIST GROUPS integer]
                  [FREELISTS  integer]
                  [OPTIMAL              {integer [K|M] | NULL}])
83.清除表数据
TRUNCATE TABLE [schema.]table | CLUSTER [schema.]cluster}
    [ {DROP |REUSE} STORAGE]

84.使什么暂时不能用
DISABLE { { UNIQUE (column [, column] )]
            | PRIMARY KEY
            | CONSTRAINT constraint }
                [CASCADE]
            | ALL TRIGGERS
85.释放的是 HWM 之上的数据块
DEALLOCATE UNUSED [ KEEP integer[K|M] ]

86.语法分析
ANALYZE
    { INDEX [schema.]index
        { {COMPUTE STATISTICS [ FOR TABLE
                              | FOR ALL [INDEXED] COLUMNS [SIZE integer]
                              | FOR COLUMNS [SIZE integer] column [SIZE integer] [column [SIZE integer]]
                              | FOR ALL INDEXES ] }
          | ESTIMATE STATISTICS [ FOR TABLE
                                | FOR ALL [INDEXED] COLUMNS [SIZE integer]
                                | FOR COLUMNS [SIZE integer] column [SIZE integer] [column [SIZE integer]]
                                | FOR ALL INDEXES ]
                                [SAMPLE integer {ROWS | PERCENT}]
          | DELETE STATISTICS
          | VALIDATE STRUCTURE [CASCADE]
          | LIST CHAINED ROWS [INTO [schema.]table] }
    | {TABLE [schema.]table | CLUSTER [schema.]cluster}
        { {COMPUTE STATISTICS [ FOR TABLE
                              | FOR ALL [INDEXED] COLUMNS [SIZE integer]
                              | FOR COLUMNS [SIZE integer] column [SIZE integer] [column [SIZE integer]]
                              | FOR ALL INDEXES ]
          | ESTIMATE STATISTICS [ FOR TABLE
                                | FOR ALL [INDEXED] COLUMNS [SIZE integer]
                                | FOR COLUMNS [SIZE integer] column [SIZE integer] [column [SIZE integer]]
                                | FOR ALL INDEXES ]
                                [SAMPLE integer {ROWS | PERCENT}]
          | DELETE STATISTICS
          | VALIDATE STRUCTURE [CASCADE]
          | LIST CHAINED ROWS [INTO [schema.]table] }}

87.归档日志
ARCHIVE LOG [THREAD integer]
 { { SEQ integer
        | CHANGE integer
        | CURRENT
        | GROUP integer
        |LOGFILE 'filename'        |NEXT
        |ALL
        |START }
        [TO 'location']
    |STOP }

88.审计
AUDIT {statement_opt | system_priv}
    [, {statement_opt | system_priv} ]
        [BY user [, user] ]
        [BY {SESSION | ACCESS}]
        [WHENEVER [NOT] SUCCESSFUL]
89.注释设置
COMMENT ON {  TABLE [schema.]{table | view | snapshot}
        | COLUMN [schema.]{table | view | snapshot}.column }
    IS 'text'
COMMIT=COMMIT [WORK]
    [ COMMENT 'text'    | FORCE 'text'[, integer] ]
CONSTRAINT clause=Column constraint:

[CONSTRAINT constraint]
{ [NOT] NULL
| {UNIQUE | PRIMARY KEY}
| REFERENCES [schema.]table [(column)]
        [ON DELETE CASCADE]
| CHECK (condition) }
{ [ USING INDEX  [PCTFREE integer]
            [INITRANS integer] [MAXTRANS integer]
            [TABLESPACE tablespace]
            [STORAGE storage_clause] ]
  [ EXCEPTIONS INTO [schema.]table
| DISABLE }
Table constraint:

[CONSTRAINT constraint]
{ {UNIQUE | PRIMARY KEY} (column [,column] )
|  FOREIGN KEY (column [,column] )
        REFERENCES [schema.]table [(column [,column] )]
        [ON DELETE CASCADE]
| CHECK (condition) }
{ [ USING INDEX  [PCTFREE integer]
            [INITRANS integer] [MAXTRANS integer]
            [TABLESPACE tablespace]
            [STORAGE storage_clause] ]
  [ EXCEPTIONS INTO [schema.]table[@dblink]
| DISABLE }