iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Complete Syntax  |  Oracle Functions  |  PL/SQL Syntax  |  SQL Syntax  |  Tables

CREATE

ALTER

DROP

OTHERS

CREATE CLUSTER
CREATE CONTEXT
CREATE CONTROLFILE
CREATE DATABASE
CREATE DATABASE LINK
CREATE DIMENSION
CREATE DIRECTORY
CREATE DISKGROUP
CREATE FUNCTION
CREATE INDEX
CREATE INDEXTYPE
CREATE JAVA
CREATE LIBRARY
CREATE MATERIALIZED VIEW
CREATE MATERIALIZED VIEW LOG
CREATE OPERATOR
CREATE OUTLINE
CREATE PACKAGE
CREATE PACKAGE BODY
CREATE PFILE
CREATE PROCEDURE
CREATE PROFILE
CREATE ROLE
CREATE ROLLBACK SEGMENT
CREATE SCHEMA AUTHORIZATION
CREATE SEQUENCE
CREATE SPFILE
CREATE SYNONYM
CREATE TABLE
CREATE TABLESPACE
CREATE TRIGGER
CREATE TYPE
CREATE TYPE BODY
CREATE USER
CREATE VIEW

ALTER CLUSTER
ALTER DATABASE
ALTER DIMENSION
ALTER DISKGROUP
ALTER FUNCTION
ALTER INDEX
ALTER INDEXTYPE
ALTER JAVA
ALTER MATERIALIZED VIEW
ALTER MATERIALIZED VIEW LOG
ALTER OPERATOR
ALTER OUTLINE
ALTER PACKAGE
ALTER PROCEDURE
ALTER PROFILE
ALTER RESOURCE COST
ALTER ROLE
ALTER ROLLBACK SEGMENT
ALTER SEQUENCE
ALTER SESSION
ALTER TABLE
ALTER TABLESPACE
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER VIEW

 

 

 

 

 

 

DROP CLUSTER
DROP CONTEXT
DROP DATABASE
DROP DATABASE LINK
DROP DIMENSION
DROP DIRECTORY
DROP DISKGROUP
DROP FUNCTION
DROP INDEX
DROP INDEXTYPE
DROP JAVA
DROP LIBRARY
DROP MATERIALIZED VIEW
DROP MATERIALIZED VIEW LOG
DROP OPERATOR
DROP OUTLINE
DROP PACKAGE
DROP PROCEDURE
DROP PROFILE
DROP ROLE
DROP ROLLBACK SEGMENT
DROP SEQUENCE
DROP SYNONYM
DROP TABLESPACE
DROP TRIGGER
DROP TYPE
DROP TYPE BODY
DROP USER
DROP VIEW

 

 

 

 

ANALYZE
ASSOCIATE STATISTICS WITH
AUDIT
CALL
COMMENT ON
COMMIT
DELETE
DISASSOCIATE STATISTICS
EXPLAIN PLAN
FLASHBACK DATABASE
FLASHBACK TABLE
GRANT
INSERT
LOCK TABLE
MERGE
NOAUDIT
PURGE
RENAME
REVOKE
ROLLBACK
SAVEPOINT
SELECT
SET CONSTRAINT[S]
SET ROLE
SET TRANSACTION
TRUNCATE
UPDATE

 

 

 

 

 

 

 

ALTER CLUSTER

ALTER CLUSTER [schema.]cluster

{physical_attributes_clause | SIZE size_clause | allocate_extent_clause | deallocate_unused_clause | {CACHE | NOCHACHE}}…

[parallel_clause];

 Right Click to go back.

 

ALTER DATABASE

ALTER DATABASE [database]

{startup_clauses | recovery_clauses | database_file_clauses | logfile_clauses | controlfile_clauses | standby_database_clauses | default_settings_clauses | redo_thread_clauses | security_clause};

 Right Click to go back.

 

ALTER DIMENSION

ALTER DIMENSION [schema.]dimension

{ADD {level_clause | hierarchy_clause | attribute_clause | extended_attribute_clause}…

{DROP {LEVEL level [RESTRICT | CASCADE] | HIERARCHY hierarchy | ATTRIBUTE attribute [LEVEL level [COLUMN column …}… COMPILE;

 Right Click to go back.

 

ALTER DISKGROUP

ALTER DISKGROUP {disk_clauses | diskgroup_clauses} …;

 Right Click to go back.

 

ALTER FUNCTION

ALTER FUNCTION [schema.]function

COMPILE [DEBUG] [compiler_parameters_clause …] [REUSE SETTING];

 Right Click to go back.

 

ALTER INDEX

ALTER INDEX [schema.]index

{{deallocate_unused_clause | allocate_extent_clause | shrink_clause | parallel_clause | physical_attributes_clause | logging_clause}… | rebuild_clause | PARAMETERS (‘ODCI_parameters’) | {ENABLE | DISABLE} |UNUSABLE | RENAME TO new_name | COALESCE | {MONITORING | NOMONITORING} USAGE | UPDATE BLOCK REFERENCES | alter_index_partitioning};

 Right Click to go back.

 

ALTER INDEXTYPE

ALTER INDEXTYPE [schema.]indextype

{{ADD | DROP} [schema.]operator (parameter_types)}… [using_type_clause] | COMPILE};

 Right Click to go back.

 

ALTER JAVA

ALTER JAVA {SOURCE | CLASS} [schema.]object_name

[RESOLVER (match_string[,]{schema_name | - })…]

{{COMPILE | RESERVE} | invoker_rights_clause};

 Right Click to go back.

 

ALTER MATERIALIZED VIEW

ALTER MATERIALIZED VIEW [schema.](materialized_view)

[physical_attributes_clause | table_compression | LOB_storage_clause… | modify_LOB_storage_clause… | alter_table_partitioning | parallel_clause | allocate_extent_clause | shrink_clause | {CACHE | NOCACHE}] [alter_iot_clauses] [USING INDEX physical_allributes_clause] [MODIFY scoped_table_ref_constraint | alter_mv_refresh] [ {ENABLE | DISABLE} QUERY REWRITE | COMPILE | CONSIDER FRESH];

 Right Click to go back.

 

ALTER MATERIALIZED VIEW LOG

ALTER MATERIALIZED VIEW LOG [FORCE] ON [schema.]table

[physical_attribute_clause | alter_table_partitioning | parallel_clause | logging_clause

| allocate_extent_clause | shrink_clause | {CACHE | NOCACHE}]

[ADD {OBJECT ID | PRIMARY KEY | ROWID | SEQUENCE}[(column [, column]…)] (column [, column]…)}… [new_values_clause]];

 Right Click to go back.

 

ALTER OPERATOR

ALTER OPERATOR [schema.]operator

{add_binding_clause | drop_binging_clause | COMPILE};

 Right Click to go back.

 

ALTER OUTLINE

ALTER OUTLINE [PUBLIC | PRIVATE] outline

{REBUILD | RENAME TO new_outline_name | CHANGE CATEGORY TO new_category_name | {ENABLE | DISABLE}}…;

 Right Click to go back.

 

ALTER PACKAGE

ALTER PACKAGE [schema.]package

COMPILE [DEBUG] [PACKAGE | SPECIFICATION | BODY] [compiler_parameters_clause]… [REUSE SETTINGS];

 Right Click to go back.

 

ALTER PROCEDURE

ALTER PROCEDURE [schema.]procedure

COMPILE [DEBUG] [compiler_parameters_clause]… [REUSE SETTINGS];

 Right Click to go back.

 

ALTER PROFILE

ALTER PROFILE profile LIMIT

[resource_parameters | password_parameters]…;

 Right Click to go back.

 

ALTER RESOURCE COST

ALTER RESOURCE COST

{CPU_PER_SESSION | CONNECT_TIME | LOGICAL_READS_PER_SESSION | PRIVATE_SGA} integer …;

 Right Click to go back.

 

ALTER ROLE

ALTER ROLE role

{NOT IDENTIFIED | IDENTIFIED {BY password | USING [schema.]package | EXTERNALLY | GLOBALLY};

 Right Click to go back.

 

ALTER ROLLBACK SEGMENT

ALTER ROLLBACK SEGMENT rollback_segment

{ONLINE | OFFLINE | storage_clause | SHRINK [ TO integer [K | M]]};

 Right Click to go back.

 

ALTER SEQUENCE

ALTER SEQUENCE [schema.]sequence

{INCREMENT BY integer | {MAXVALUE integer | NOMAXVALUE} | {MINVALUE integer | NOMINVALUE} | {CYCLE | NOCYCLE} | {CACHE integer  | NOCACHE} | {ORDER | NOORDER}]…;

 Right Click to go back.

 

ALTER SESSION

ALTER SESSION {archive_log_clause | checkpoint_clause | check_datafiles_clause | DUMP ACTIVE SESSION HISTORY [MINUTES integer ] distributed_recov_clauses FLUSH {SHARED_POOL | BUFFER_CACHE} end_session_clauses SWITCH LOGFILE {SUSPEND | RESUME} | quiesce_clauses | shutdown_dispatcher_clause | REGISTER | SET alter_system_set_clause… | RESET alter_system_reset_clause… };

 Right Click to go back.

 

ALTER TABLE

ALTER TABLE [schema.]table

[alter_table_properties | column_clauses | constraint_clauses | alter_table_partitioning | alter_external_table_clauses | move_table_clause]

[enable_diable_clause | {ENABLE | DIABLE} {TABLE LOCK | ALL TRIGGERS}]…;

 Right Click to go back.

 

ALTER TABLESPACE

ALTER TABLESPACE tablespace

{DEFAULT [table_compression] storage_clause | MINIMUM EXTENT integer [K|M] | RESIZE size_clause | COALESCE | RENAME TO new_tablespace_name | {BEGIN | END} BACKUP | datafile_tempfile_clauses | tablespace_logging_clauses | tablespace_group_clauses | tablespace_state_clauses | autoextend_clause | flashback_mode_clause | tablespace_retention_clause};

 Right Click to go back.

 

ALTER TRIGGER

ALTER TRIGGER [schema.]trigger

{ENABLE | DISABLE | RENAME TO new_name | COMPILE [DEBUG] [compiler_parameters_clause]… [REUSE SETTING]};

 Right Click to go back.

 

ALTER TYPE

ALTER TYPE [schema.]type

{compile_type_clause | replace_type_clause | {alter_method_spec | alter_attribute_definition | alter_collection_clauses | [NOT] {INSTANTIABLE | FINAL}} [dependent_handling_clause]};

 Right Click to go back.

 

ALTER USER

ALTER USER {user {IDENTIFIED {BY password [REPLACE old_password] | EXTERNALLY | GLOBALLY AS ‘external_name’} | DEFAULT TABLESPACE tablespace | TEMPORARY TABLESPACE {tablespace | tablespace_group_name} | QUOTA {integer [ K | M ] | UNLIMITED } ON tablespace … | PROFILE profile | DEFAULT ROLE {role, … | ALL [ EXCEPT role, … | NONE } | PASSWORD EXPIRE | ACCOUNT { LOCK | UNLOCK}} … proxy_clause;

 Right Click to go back.

 

ALTER VIEW

ALTER VIEW [schema.]view

{ADD out_of_line_constraint | MODIFY CONSTRAINT constraint {RELY | NORELY} | DROP {CONSTRAINT constraint | PRIMARY KEY | UNIQUE (column, …) | COMPILE};

 Right Click to go back.

 

ANALYZE

ANALYZE {TABLE [schema.]table

[PARTITION (partition) | SUBPARTITION (subpartition)] | INDEX [schema.]index [PARTITION (partition) | SUBPARTITION (subpartition)] | CLUSTER [schema.]cluster}{validation_clauses | LIST CHAINED ROWS [into_clause] | DELETE [SYSTEM] STATISTICS | compute_statistics_clause | estimate_statistics_clause};

 Right Click to go back.

 

ASSOCIATE STATISTICS WITH

ASSOCIATE STATISTICS WITH {column_association | function_association};

 Right Click to go back.

 

AUDIT

AUDIT {sql_statement_clause | schema_object_clause} [BY{SESSION | ACCESS}] [WHENEVER [NOT] SUCCESSFUL];

 Right Click to go back.

 

CALL

CALL {routine_clause | object_access_expression}[INTO :host_variable [[INDICATOR] :indicator_variable]];

 Right Click to go back.

 

COMMENT ON

COMMENT ON {TABLE [schema.]{table | view} | COLUMN [schema.]{table. | view. | materialized_view.}column | OPERATOR [schema.] operator | INDEXTYPE [schema.]indextype | MATERIALIZED VIEW materialized_view} IS ‘text’;

 Right Click to go back.

 

COMMIT

COMMIT [WORK] [COMMENT ‘text’ | FORCE ‘text’ [,integer]];

 Right Click to go back.

 

CREATE CLUSTER

CREATE CLUSTER [schema.]cluster

(column datatype [SORT], …) [{physical_attributes_clause | SIZE size_clause | TABLESPACE tablespace | {INDEX | [SINGLE TABLE] HASHKEYS integer [HASH is expr]}}]…

[parallel_clause] [NOROWDEPENDENCIES | ROWDEPENDENCIES] [CACHE | NOCACHE];

 Right Click to go back.

 

CREATE CONTEXT

CREATE OR REPLACE CONTEXT namespace

USING [schema.]package [INITIALIZED {EXTERNALLY | GLOBALLY} | ACCESSED GLOBALLY];

 Right Click to go back.

 

CREATE CONTROLFILE

CREATE CONTROLFILE [REUSE] [SET] DATABASE database [logfile_clause] {RESETLOGS | NORESETLOGS} [DATAFILE file_specification, file_specification, …] [{MAXLOGFILES integer | MAXLOGMEMBERS integer | MAXLOGHISTORY integer | MAXDATAFILES integer | {ARCHIVELOG | NOARCHIVELOG} | FORCE LOGGING}…] [character_set_clause];

 Right Click to go back.

 

CREATE DATABASE

CREATE DATABASE [database]

{USER SYS IDENTIFIED BY password | USER SYSTEM IDENTIFIED BY password | CONTROLFILE REUSE | MAXDATAFILES integer | MAXINSTANCES integer | CHARACTER SET charset | NATIONAL CHARACTER SET charset | SET DEFAULT {BIGFILE | SMALLFILE} TABLESPACE | database_logging_clauses | tablespace_clauses | set_time_zone_clause}…;

 Right Click to go back.

 

CREATE DATABASE LINK

CREATE [SHARED] [PUBLIC] DATABASE LINK dblink

[CONNECT TO {CURRENT_USER | user IDENTIFIED BY password [dblink_authentication]} | dblink_authentication ] [USING ‘connect_string’];

 Right Click to go back.

 

CREATE DIMENSION

CREATE DIMENSION [schema.]dimension level_clause … {hierarchy_clause | attribute_clause | extended_attribute_clause}…;

 Right Click to go back.

 

CREATE DIRECTORY

CREATE [OR REPLACE] DIRECTORY directory AS ‘path_name’;

 Right Click to go back.

 

CREATE DISKGROUP

CREATE DISKGROUP diskgroup_name

[{HIGH | NORMAL | EXTERNAL} REDUNDANCY]

[FAILGROUP failgroup_name] DISK qualified_disk_clause, …

[FAILGROUP failgroup_name] DISK qualified_disk_clause, …;

 Right Click to go back.

 

CREATE FUNCTION

CREATE [OR REPLACE] FUNCTION [schema.]function

[(argument [IN | OUT | IN OUT] [NOCOPY] datatype, argument…)]

RETURN datatype [{invoker_rights_clause | DETERMINISTIC | parallel_enable_clause}…

{{AGGREGATE | PIPELINED} USING [schema.]implementation_type | [PIPELINED] {IS | AS} {pl/sql_function_body | call_spec}};

 Right Click to go back.

 

CREATE INDEX

CREATE [UNIQUE | BITMAP] INDEX [schema.]index

ON {cluster_index_clause | table_index_clause | bitmap_join_index_clause};

 Right Click to go back.

 

CREATE INDEXTYPE

CREATE [OR REPLACE] INDEXTYPE [schema.]indextype

FOR [[schema.]operator (parameter_type,…),] … using_type_clause;

 Right Click to go back.

 

CREATE JAVA

CREATE [OR REPLACE] [AND {RESOLVE | COMPILE}][NOFORCE]

JAVA {{SOURCE | RESOURCE} NAMED [schema.]primary_name | CLASS [SCHEMA schema]} [invoker_rights_clause][RESOLVER ((match_string[,]{schema_name | -})[((match_string[,]{schema_name | -})]…]

{USING {BFILE (directory_object_name, server_file_name) | {CLOB | BLOB | BFILE} subquery | ‘key_for_BLOB’} | AS source_text};

 Right Click to go back.

 

CREATE LIBRARY

CREATE [OR REPLACE] LIBRARY [schema.]library

{IS | AS} ‘filename’ [AGENT ‘agent_dblink’];

 Right Click to go back.

 

CREATE MATERIALIZED VIEW

CREATE MATERIALIZED VIEW [schema.]materialized_view

[OF [schema.]object_type] [(scoped_table_ref_constraint)]{ON PREBUILT TABLE [{WITH | WITHOUT} REDUCED PRECISION] | physical_properties materialized_view_props} [USING INDEX [physical_attributes_clause | TABLESPACE tablespace]… | USING NO INDEX] [create_mv_refresh] [FOR UPDATE] [{DISABLE | ENABLE} QUERY REWRITE] AS subquery;

 Right Click to go back.

 

CREATE MATERIALIZED VIEW LOG

CREATE MATERIALIZED VIEW LOG ON [schema.]table

[physical_attributes_clause | TABLESPACE tablespace | logging_clause | {CACHE | NOCACHE}]…][parallel_clause][table_partitioning_clauses][WITH {OBJECT ID |PRIMARY KEY | ROWID | SEQUENCE | (column [, column]…)}…

[new_values_clause]];

 Right Click to go back.

 

CREATE OPERATOR

CREATE [OR REPLACE] OPERATOR [schema.]operator binding_clause;

 Right Click to go back.

 

CREATE OUTLINE

CREATE [OR REPLACE] [PUBLIC | PRIVATE] OUTLINE [outline] [FROM [PUBLIC | PRIVATE] source_outline][FOR CATEGORY category] [ON statement];

 Right Click to go back.

 

CREATE PACKAGE

CREATE [OR REPLACE] PACKAGE [schema.]package

[invoker_rights_clause]

{IS | AS} pl/sql_package_spec;

 Right Click to go back.

 

CREATE PACKAGE BODY

CREATE [OR REPLACE] PACKAGE BODY [schema.]package

{IS | AS} pl/sql_package_body;

 Right Click to go back.

 

CREATE PFILE

CREATE PFILE [= ‘pfile_name’] FROM SPFILE [= ‘spfile_name’];

 Right Click to go back.

 

CREATE PROCEDURE

CREATE [OR REPLACE] PROCEDURE [schema.]procedure

[(argument [IN | OUT | IN OUT] [NOCOPY] datatype [, argument …] …)]

[invoker_rights_clause] {IS | AS} {pl/sql_subprogram_body | call_spec};

 Right Click to go back.

 

CREATE PROFILE

CREATE PROFILE profile LIMIT

{resource_parameters | password_parameters}…;

 Right Click to go back.

 

CREATE ROLE

CREATE ROLE role [NOT IDENTIFIED | IDENTIFIED {BY password | USING [schema.]package | EXTERNALLY | GLOBALLY}];

 Right Click to go back.

 

CREATE ROLLBACK SEGMENT

CREATE [PUBLIC] ROLLBACK SEGMENT rollback_segment [{TABLESPACE tablespace | storage_clause}…];

 Right Click to go back.

 

CREATE SCHEMA AUTHORIZATION

CREATE SCHEMA AUTHORIZATION schema {create_table_statement | create_view_statement | grant_statement}…;

 Right Click to go back.

 

CREATE SEQUENCE

CREATE SEQUENCE [schema.]sequence

[INCREMENT BY  integer | START WITH integer | {MAXVALUE integer | NOMAXVALUE} | {MINVALUE integer | NOMINVALUE} | {CYCLE | NOCYCL} | {ORDER | NOORDER}]…;

 Right Click to go back.

 

CREATE SPFILE

CREATE SPFILE [=’spfile_name’] FROM PFILE [=’pfile_name’;

 Right Click to go back.

 

CREATE SYNONYM

CREATE [OR REPLACE] [PUBLIC] SYNONYM [schema.]synonym

FOR [schema.]object[@dblink];

 Right Click to go back.

 

CREATE TABLE

CREATE [GLOBAL TEMPORARY] TABLE [schema.]table

[(relational_properties)]

[ON COMMIT {DELETE | PRESERVE} ROWS] [physical_properties] [table_properties];

 Right Click to go back.

 

CREATE TABLESPACE

CREATE [BIGFILE | SMALLFILE] {permanent_tablespace_clause | temporary_tablespace_clause | undo_tablespace_clause};

 Right Click to go back.

 

CREATE TRIGGER

CREATE [OR REPLACE] TRIGGER [schema.]trigger

{BEFORE | AFTER | INSTEAD OF} {dml_event_clause | {ddl_event [OR ddl_event]…} ON {[schema.]SCHEMA | DATABASE}}[WHEN (condition)]

{pl/sql_block | call_procedure_statement};

 Right Click to go back.

 

CREATE TYPE

{create_incomplete_type | create_object_type | create_varray_type | create_nested_table_type}

 Right Click to go back.

 

CREATE TYPE BODY

CREATE [OR REPLACE] TYPE BODY [schema.]type_name

{IS | AS} {subprogram_declaration | map_order_func_declaration}

[;{subprogram_declaration | map_order_func_declaration}]…

END;

 Right Click to go back.

 

CREATE USER

CREATE USER user IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS ‘external_name’}[DEFAULT TABLESPACE tablespace | TEMPORARY TABLESPACE {tablespace | tablespace_group} | QUOTA {integer [K|M] | UNLIMITED } ON tablespace… | PROFILE profile | PASSWORD EXPIRE | ACCOUNT {LOCK | UNLOCK}]…;

 Right Click to go back.

 

CREATE VIEW

CREATE [OR REPLACE] [[NO] FORCE] VIEW [schema.]view

[(alias[inline_constraint]…| out_of_line_constraint [inline_constraint]…]…) | object_view_clause | XMLType_view_clause] AS subquery [subquery_restriction_clause];

 Right Click to go back.

 

DELETE

DELETE [hint] [FROM] {dml_table_expression_clause | ONLY (dml_table_expression_clause)}[t-alias][where_clause][returning_clause];

 Right Click to go back.

 

DISASSOCIATE STATISTICS

DISASSOCIATE STATISTICS FROM {COLUMNS [schema.]table.column, [[schema.]table.column]… | FUNCTIONS [schema.]function, [[schema.]function]… | PACKAGES [schema.]package, [[schema.]package]… | TYPES [schema.]type, [[schema.]type]… | INDEXES [schema.]index, [[schema.]index]… | INDEXTYPES [schema.]indextype, [[schema.]indextype]… } [FORCE];

 Right Click to go back.

 

DROP CLUSTER

DROP CLUSTER [schema.]cluster

[INCLUDING TABLES [CASCADE CONSTRAINTS]];

 Right Click to go back.

 

DROP CONTEXT

DROP CONTEXT namespace;

 Right Click to go back.

 

DROP DATABASE

DROP DATABASE;

 Right Click to go back.

 

DROP DATABASE LINK

DROP [PUBLIC] DATABASE LINK dblink;

 Right Click to go back.

 

DROP DIMENSION

DROP DIMENSION [schema.]dimension;

 Right Click to go back.

 

DROP DIRECTORY

DROP DIRECTORY directory_name;

 Right Click to go back.

 

DROP DISKGROUP

DROP DISKGROUP diskgroup_name

[{INCLUDING | EXCLUDING} CONTENTS];

 Right Click to go back.

 

DROP FUNCTION

DROP FUNCTION [schema.]function_name;

 Right Click to go back.

 

DROP INDEX

DROP INDEX [schema.]index [FORCE];

 Right Click to go back.

 

DROP INDEXTYPE

DROP INDEXTYPE [schema.]indextype [FORCE];

 Right Click to go back.

 

DROP JAVA

DROP JAVA {SOURCE | CLASS | RESOURCE} [schema.]object_name;

 Right Click to go back.

 

DROP LIBRARY

DROP LIBRARY library_name;

 Right Click to go back.

 

DROP MATERIALIZED VIEW

DROP MATERIALIZED VIEW [schema.]materialized_view

[PRESERVE TABLE];

 Right Click to go back.

 

DROP MATERIALIZED VIEW LOG

DROP MATERIALIZED VIEW LOG ON [schema.]table;

 Right Click to go back.

 

DROP OPERATOR

DROP OPERATOR [schema.]operator [FORCE];

 Right Click to go back.

 

DROP OUTLINE

DROP OUTLINE outline;

 Right Click to go back.

 

DROP PACKAGE

DROP PACKAGE [BODY] [schema.]package;

 Right Click to go back.

 

DROP PROCEDURE

DROP PROCEDURE [schema.]procedure;

 Right Click to go back.

 

DROP PROFILE

DROP PROFILE profile [CASCADE];

 Right Click to go back.

 

DROP ROLE

DROP ROLE role;

 Right Click to go back.

 

DROP ROLLBACK SEGMENT

DROP ROLLBACK SEGMENT rollback_segment;

 Right Click to go back.

 

DROP SEQUENCE

DROP SEQUENCE [schema.]sequence_name;

 Right Click to go back.

 

DROP SYNONYM

DROP [PUBLIC] SYNONYM [schema.]synonym [FORCE];

 Right Click to go back.

 

DROP TABLESPACE

DROP TABLESPACE tablespace_name

[INCLUDING CONTENTS [ AND DATAFILES] [CASCADE CONSTRAINTS]];

 Right Click to go back.

 

DROP TRIGGER

DROP TRIGGER [schema.]trigger_name;

 Right Click to go back.

 

DROP TYPE

DROP TYPE [schema.]type_name [FORCE | VALIDATE];

 Right Click to go back.

 

DROP TYPE BODY

DROP TYPE BODY [schema.]type_name;

 Right Click to go back.

 

DROP USER

DROP USER user [CASCADE];

 Right Click to go back.

 

DROP VIEW

DROP VIEW [schema.]view [CASCADE CONSTRAINTS];

 Right Click to go back.

 

EXPLAIN PLAN

EXPLAIN PLAN

[SET STATEMENT_ID = ‘text’]

[INTO [schema.]table[@dblink]] FOR sql_statement;

 Right Click to go back.

 

FLASHBACK DATABASE

FLASHBACK [STANDBY] DATABASE [database_name]

{TO {SCN | TIMESTAMP} expr | TO BEFORE {SCN | TIMESTAMP} expr};

 Right Click to go back.

 

FLASHBACK TABLE

FLASHBACK TABLE [schema.]table, [[schema.]table], … TO {{SCN TIMESTAMP} expr [{ENABLE | DISABLE} TRIGGERS ] | BEFORE DROP [RENAME TO table] };

 Right Click to go back.

 

GRANT

GRANT {grant_system_privileges | grant_object_privileges};

 Right Click to go back.

 

INSERT

INSERT [hint] {single_table_insert | multi_table_insert};

 Right Click to go back.

 

LOCK TABLE

LOCK TABLE [schema.]{table | view}

[{PARTITION (partition) | SUBPARTITION (subpartition)} | @dblink]…

IN lockmode MODE [NOWAIT];

 Right Click to go back.

 

MERGE

MERGE [hint] INTO [schema.]table [t_alias]

USING [schema.]{table | view | subquery} [t_alias] ON (condition)

[merge_update_clause][merge_insert_clause];

 Right Click to go back.

 

NOAUDIT

{sql_statement_clause… | schema_object_clause…}

[WHENEVER [NOT] SUCCESSFUL];

 Right Click to go back.

 

PURGE

PURGE {{TABLE table | INDEX index} | {RECYCLEBIN | DBA_RECYCLEBIN} | TABLESPACE tablespace [USER user]};

 Right Click to go back.

 

RENAME

RENAME old_name TO new_name;

 Right Click to go back.

 

REVOKE

REVOKE {revoke_system_privileges | revoke_object_privileges};

 Right Click to go back.

 

ROLLBACK

ROLLBACK [WORK] [TO [SAVEPOINT] savepoint | FORCE ‘text’];

 Right Click to go back.

 

SAVEPOINT

SAVEPOINT savepoint;

 Right Click to go back.

 

SELECT

Subquery [for_update_clause];

 Right Click to go back.

 

SET CONSTRAINT[S]

SET {CONSTRAINT | CONSTRAINTS}

{constraint,… | ALL} {IMMEDIATE | DEFERRED};

 Right Click to go back.

 

SET ROLE

SET ROLE {role [IDENTIFIED BY password]}… | ALL [EXCEPT role,…] | NONE;

 Right Click to go back.

 

SET TRANSACTION

SET TRANSACTION {{READ {ONLY | WRITE} | ISOLATION LEVEL {SERIALIZABLE | READ COMMITTED} | USE ROLLBACK SEGMENT rollback_segment} [NAME ‘text’] | NAME ‘text’};

 Right Click to go back.

 

TRUNCATE

TRUNCATE {TABLE [schema.]table [{PRESERVE | PURGE} MATERIALIZED VIEW LOG] | CLUSTER [schema.]cluster} [{DROP | REUSE} STORAGE];

 Right Click to go back.

 

UPDATE

UPDATE [hint] {dml_table_expression_clause | ONLY (dml_table_expression_clause)} [t_alias] update_set_clause [where_clause][returning_clause];

 Right Click to go back.

 

 

 

[activite_standby_db_clause]

ACTIVATE [PHYSICAL | LOGICAL] STANDBY DATABASE [SKIP [STANDBY LOGFILE]]

 Right Click to go back.

 

[add_binding_clause]

ADD BINDING (parameter_type,…) RETURN (return_type) [implementation_clause] using_function_clause

 Right Click to go back.

 

[add_column_clause]

ADD (column datatype [DEFAULT expr][{inline_constraint… | inline_ref_constraint…}),… [column_properties]

 Right Click to go back.

 

[add_disk_clause]

ADD [[FAILGROUP failgroup_name] DISK qualified_disk_clause,…]…

 Right Click to go back.

 

[add_hash_index_partition]

ADD PARTITION [partition_name][TABLESPACE tablespace_name][parallel_clause]

 Right Click to go back.

 

[add_hash_partition_clause]

ADD PARTITION [partition] partitioning_storage_clause [update_index_clauses] [parallel_clause]

 Right Click to go back.

 

[add_hash_subpartition]

ADD subpartition_spec [update_index_clauses][parallel_clause]

 Right Click to go back.

 

[add_list_partition_clause]

ADD PARTITION [partition] list_values_clause [table_partition_description] [update_index_clauses]

 Right Click to go back.

 

[add_list_subpartition]

ADD subpartition_spec [update_index_clauses]

 Right Click to go back.

 

[add_logfile_clauses]

ADD [STANDBY] LOGFILE {[INSTANCE ‘instance_name’ | THREAD integer]

[[GROUP integer] redo_log_file_spec],… | [MEMBER ‘filename’ [REUSE]],… TO logfile_descriptor,…}

 Right Click to go back.

 

[add_overflow_clause]

ADD OVERFLOW [segment_attributes_clause] [(PARTITION [segment_attributes_clause], PARTITION…]…)]

 Right Click to go back.

 

[add_range_partition_clause]

ADD PARTITION [partition] range_values_clause [table_partition_description] [update_index_clauses]

 Right Click to go back.

 

[add_table_partition]

{add_range_partition_clause | add_hash_partition_clause | add_list_parition_clause}

 Right Click to go back.

 

[alias_file_name]

+diskgroup [(template_name)] /alias_name

 Right Click to go back.

 

[allocate_extent_clause]

ALLOCATE EXTENT ({SIZE size_clause | DATAFILE ‘filename’ | INSTANCE integer}…)

 Right Click to go back.

 

[alter_attribute_definition]

{ADD | MODIFY} ATTRIBUTE ({attribute [datatype]},…) | DROP ATTRIBUTE (attribute,…)

 Right Click to go back.

 

[alter_collection_clauses]

MODIFY {LIMIT integer | ELEMENT TYPE datatype}

 Right Click to go back.

 

[alter_datafile_clause]

DATAFILE {‘filename’ | filenumber},… {ONLINE | OFFLINE [FOR DROP] | RESIZE size_clause | autoextend_clause | END BACKUP}

 Right Click to go back.

 

[alter_external_table_clauses]

{add_column_clause | modify_column_clauses | drop_column_clause | parallel_clause | external_data_properties | REJECT LIMIT {integer | UNLIMITED} | PROJECT COLUMN {ALL | REFERENCED}}…

 Right Click to go back.

 

[alter_index_partitioning]

{modify_index_default_attrs | add_hash_index_partition | modify_index_partition | rename_index_partition | drop_index_partition | split_index_partition | coalesce_index_partition | modify_index_subpartition}

 Right Click to go back.

 

[alter_iot_clauses]

{index_org_table_clause | alter_overflow_clause | alter_mapping_table_clauses | COALESCE}

 Right Click to go back.

 

[alter_mapping_table_clauses]

MAPPING TABLE {UPDATE BLOCK REFERENCES | allocate_extent_clause | deallocate_unused_clause}

 Right Click to go back.

 

[alter_method_spec]

[{ADD | DROP}{map_order_function_spec | subprogram_spec}]…

 Right Click to go back.

 

[alter_mv_refresh]

REFRESH {{FAST | COMPLETE | FORCE} | ON {DEMAND | COMMIT}| {START WITH | NEXT} date | WITH PRIMARY KEY | USING {DEFAULT MASTER ROLLBACK SEGMENT | MASTER ROLLBACK SEGMENT rollback_segment} | USING {ENFORCED | TRUSTED} CONSTRAINTS}

 Right Click to go back.

 

[alter_overflow_clause]

{OVERFLOW {allocate_extent_clause | deallocate_unused_clause}… | add_overflow_clause}

 Right Click to go back.

 

[alter_session_set_clause]

SET <parameter_name = parameter_value> …

 Right Click to go back.

 

[alter_system_reset_clause]

parameter_name [SCOPE = {MEMORY | SPFILE | BOTH}] SID = ‘sid’

 Right Click to go back.

 

[alter_system_set_clause]

parameter_name = parameter_value, … [COMMENT ‘text’] [DEFERRED] [SCOPE = {MEMORY | SPFILE | BOTH}] [SID = {‘sid’ | *}]

 Right Click to go back.

 

[alter_table_partitioning]

{ modify_table_default_attrs | set_subpartition_template | modify_table_partition | modify_table_subpartition | move_table_partition | move_table_subpartition | add_table_partition | coalesce_table_partition | drop_table_partition | drop_table_subpartition | rename_partition_subpart | truncate_partition_subpart | split_table_partition | split_table_subpartition | merge_table_partitions | merge_table_subpartitions | exchange_partition_subpart}

 Right Click to go back.

 

[alter_table_properties]

{physical_attributes_clause | logging_clause | table_compression | supplemental_table_logging | allocate_extent_clause | deallocate_unused_clause | shrink_clause | {CACHE | NOCACHE} | upgrade_table_clause | records_per_block_clause | parallel_clause | row_movement_clause}… | RENAME TO new_table_name} [alter_iot_clauses]

 Right Click to go back.

 

[alter_tempfile_clause]

TEMPFILE {‘filename’,…}{RESIZE size_clause | autoextend_clause | DROP [INCLUDING DATAFILES] | ONLINE | OFFLINE}

 Right Click to go back.

 

[alter_varray_col_properties]

MODIFY VARRY varray_item (modify_LOB_parameters)

 Right Click to go back.

 

[analytic_clause]

[query_partition_clause][order_by_clause [windowing_clause]]

 Right Click to go back.

 

[archive_log_clause]

ARCHIVE LOG [INSTANCE ‘instance_name’ | THREAD integer]

{{SEQUENCE integer | CHANGE integer | CURRENT [NOSWITCH] | GROUP integer | LOGFILE ‘filename’ [USING BACKUP CONTROLFILE] | NEXT | ALL | START} [TO ‘location’] | STOP}

 Right Click to go back.

 

[array_DML_clause]

[WITH | WITHOUT] ARRAY DML [(schema.]type, [schema].varray_type),…]

 Right Click to go back.

 

[attribute_clause]

ATTRIBUTE level DETERMINES (dependent_column,…)

 Right Click to go back.

 

[auditing_by_clause]

BY proxy,… | user,…

 Right Click to go back.

 

[auditing_on_clause]

ON [schema.]object | DIRECTORY directory_name | DEFAULT

 Right Click to go back.

 

[autoextend_clause]

AUTOEXTEND OFF | ON [NEXT size_clause] [maxsize_clause]

 Right Click to go back.

 

[binding_clause]

BINDING [(parameter_type,…) RETURN return_type [implementation_clause] using_function_clause],…

 Right Click to go back.

 

[bitmap_join_index_clause]

[schema.]table (column [ASC | DESC], column…) FROM [table [t_alias]],… WHERE condition [local_partitioned_index] index_attributes

 Right Click to go back.

 

[build_clause]

BUILD {IMMEDIATE | DEFERRED}

 Right Click to go back.

 

[c_declaration]

C [NAME name] LIBRARY lib_name [AGENT IN (argument,…)] [WITH CONTEXT] [PARAMETERS (parameter,…)]

 Right Click to go back.

 

[call_spec]

LANGUAGE {java_declaration | c_declaration}

 Right Click to go back.

 

[cancel_clause]

CANCEL [IMMEDIATE] [WAIT | NOWAIT]

 Right Click to go back.

 

[cell_assignment]

measure_column {condition | expr | single_column_for_loop},… | multi_column_for_loop

 Right Click to go back.

 

[cell_reference_options]

[{IGNORE | KEEP} NAV] [UNIQUE {DIMENSION | SINGLE REFERENCE}]

 Right Click to go back.

 

[character_set_clause]

CHARACTER SET character_set

 Right Click to go back.

 

[check_datafiles_clause]

CHECK DATAFILES [GLOBAL | LOCAL]

 Right Click to go back.

 

[check_diskgroup_clauses]

{CHECK ALL | DISK disk_name, … | DISKS IN FAILGROUP failgroup_name, … | FILE filename, …}… [REPAIR | NOREPAIR]

 Right Click to go back.

 

[checkpoint_clause]

CHECKPOINT [GLOBAL | LOCAL]

 Right Click to go back.

 

[clauster_index_clause]

CLUSTER [schema.]cluster index_attributes

 Right Click to go back.

 

[coalesce_index_partition]

COALESCE PARTITION [parallel_clause]

 Right Click to go back.

 

[coalesce_table_partition]

COALESCE PARTITION [update_index_clause] [parallel_clause]

 Right Click to go back.

 

[column_association]

COLUMNS [schema.]table.column, … using_statististics_type

 Right Click to go back.

 

[column_clauses]

{add_column_clause | modify_column_clause | drop_column_clause}… |  rename_column_clause | modify_collection_retrieval … | modify_LOB_storage_clause | alter_varray_col_properties

 Right Click to go back.

 

[column_properties]

{object_type_col_properties | nested_table_col_properties | {varray_col_properties | LOB_storage_clause} ([LOB_partition_storage],…) | XMLType_column_properties}…

 Right Click to go back.

 

[commit_switchover_clause]

{PREPARE | COMMIT} TO SWITCHOVER [ TO {{PHYSICAL STANDBY [{WITH | WITHOUT} SESSION SHUTDOWN {WAIT | NOWAIT}] | LOGICAL STANDBY} | CANCEL]

 Right Click to go back.

 

[compile_type_clause]

COMPILE [DEBUG] [SPECIFICATION | BODY] [compiler_parameters_clause…] [REUSE SETTINGS]

 Right Click to go back.

 

[compiler_parameters_clause]

parameter_name = parameter_value

 Right Click to go back.

 

[composite_partitioning]

PARTITION BY RANGE (column_list) [subpartition_by_list | subpartition_by_hash] [(PARTITION [partition] range_values_clause table_partition_description],…)

 Right Click to go back.

 

[compute_statistics_clause]

COMPUTE [SYSTEM] STATISTICS [for_clause]

 Right Click to go back.

 

[conditional_insert_clause]

[ALL | FIRST] [WHEN condition

THEN [insert_into_clause [values_clause] [error_logging_clause]]…]…

ELSE [insert_into_clause [values_clause] [error_logging_clause]]…]…

 Right Click to go back.

 

[constraint]

{inline_constraint | out_of_line_constraint | inline_ref_constraint | out_of_line_ref_constraint}

 Right Click to go back.

 

[constraint_clauses]

{ADD {out_of_line_constraint… | out_of_line_ref_constraint} | MODIFY {CONSTRAINT constraint | PRIMARY KEY | UNIQUE (column,…)} constraint_state | RENAME CONSTRAINT old_name TO new_name | drop_constraint_clause}

 Right Click to go back.

 

[constraint_state]

[[NOT] DEFERRABLE] [INITIALLY {IMMEDIATE | DEFERRED}] [RELY | NORELY] [using_index_clause] [ENABLE | DISABLE] [VALIDATE | NOVALIDATE] [exceptions_clause]

 Right Click to go back.

 

[constructor_declaration]

[FINAL] [INSTANTIABLE] CONSTRUCTOR FUNCTION datatype [[SELF IN OUT datatype, ] parameter,… RETURN SELF AS RESULT {IS | AS} {pl/sql_block | call_spec}

 Right Click to go back.

 

[constractor_spec]

[FINAL] [INSTANTIABLE] CONSTRUCTOR FUNCTION datatype [[SELF IN OUT datatype, ] parameter,… RETURN SELF AS RESULT [{IS | AS} call_spec]

 Right Click to go back.

 

[context_clause]

[WITH INDEX CONTEXT, SCAN CONTEXT implementation_type [COMPUTE ANCILLARY DATA]][WITH COLUMN CONTEXT]

 Right Click to go back.

 

[controlfile_clauses]

{CREATE [ LOGICAL |  PHYSICAL ] STANDBY CONTROLFILE AS ‘filename’ [RENAME] | BACKUP CONTROLFILE TO {‘filename’ [REUSE] | trace_file_clause} }

 Right Click to go back.

 

[create_datafile_clause]

CREATE DATAFILE {‘filename’ | filenumber}… [AS {file_specification, … | NEW}]

 Right Click to go back.

 

[create_incomplete_type]

CREATE [OR REPLACE] TYPE [schema.]type_name;

 Right Click to go back.

 

[create_mv_refresh]

{REFRESH {{FAST | COMPLETE | FORCE} | ON {DEMAND | COMMIT} | {START WITH | NEXT} date | WITH {PRIMARY KEY | ROWID} | USING {DEFAULT [MASTER | LOCAL] ROLLBACK SEGMENT} | [DEFAULT [ MASTER | LOCAL] ROLLBACK SEGMENT rollback_segment]… | USING {ENFORCED | TRUNCATED} CONSTRAINTS}… | NEVER REFRESH}

 Right Click to go back.

 

[create_nested_table_type]

CREATE [OR REPLACE] TYPE [schema.]type_name [OID ‘object_identifier’] {IS | AS} TABLE OF datatype;

 Right Click to go back.

 

[create_object_type]

CREATE [OR REPLACE] TYPE [schema.]type_name [OID ‘object_identifier’][invoker_rights_clause]{{IS | AS} OBJECT | UNDER [schema.]supertype} [sqlj_object_type][(attribute datatype [sqlj_object_type_attr][,attribute datatype [sqlj_object_type_attr]… [,element_spec[, element_spec]…)][[NOT] FINAL] [[NOT]INSTANTIABLE];

 Right Click to go back.

 

[create_varray_type]

CREATE [OR REPLACE] TYPE [schema.]type_name [OID ‘object_identifier’] {IS | AS} {VARRAY | VARYING ARRAY} (limit) OF datatype;

 Right Click to go back.

 

[database_file_clauses]

{RENAME FILE ‘filename’,… TO ‘filename’ | create_datafile_clause | alter_datafile_clause | alter_tempfile_clause}

 Right Click to go back.

 

[database_logging_clauses]

{LOGFILE [GROUP integer] file_specification, GROUP …

| MAXLOGFILES integer | MAXLOGMEMBERS integer | MAXLOGHISTORY integer | {ARCHIVELOG | NOARCHIVELOG} | FORCE LOGGING}

 Right Click to go back.

 

[datafile_tempfile_clauses]

{ADD {DATAFILE | TEMPFILE} [file_specification,…] | RENAME DATAFILE ‘filename’,… TO ‘filename’,… | {DATAFILE | TEMPFILE}{ONLINE | OFFLINE}}

 Right Click to go back.

 

[datafile_tempfile_spec]

[‘filename’][SIZE size_clause][REUSE][autoextend_clause]

 Right Click to go back.

 

[dblink]

database[.domain[.domain]…][@connect_descriptor]

 Right Click to go back.

 

[dblink_authentication]

AUTHENTICATED BY user IDENTIFIED BY password

 Right Click to go back.

 

[deallocate_unused_clause]

DEALLOCATE UNUSED [KEEP size_clause]

 Right Click to go back.

 

[default_cost_clause]

DEFAULT COST (cpu_cost, io_cost, network_cost)

 Right Click to go back.

 

[default_selectivity_clause]

DEFAULT SELECTIVITY default_selectivity

 Right Click to go back.

 

[default_tablespace]

DEFAULT TABLESPACE tablespace [DATAFILE datafile_tempfile_spec] extent_management_clause

 Right Click to go back.

 

[default_settings_clauses]

{SET DEFAULT {BIGFILE | SMALLFILE} TABLESPACE | DEFAULT TABLESPACE tablespace | DEFAULT TEMPORARY TABLESPACE {tablespace | tablespace_group_name} | RENAME GLOBAL_NAME TO database.domain[.domain]… | {ENABLE BLOCK CHANGE TRACKING [USING FILE ‘filename’ [REUSE]] | DISABLE BLOCK CHANGE TRACKING} | flashback_mode_clause | set_time_zone_clause}

 Right Click to go back.

 

[default_temp_tablespace]

[BIGFILE | SMALLFILE] DEFAULT TEMPORARY TABLESPACE tablespace [TEMPFILE file_specification,…] extent_management_clause

 Right Click to go back.

 

[dependent_handling_clause]

{INVALIDATE | CASCADE [{[NOT] INCLUDING TABLE DATA | CONVERT TO SUBSTITUTABLE}][[FORCE] exceptions_clause]}

 Right Click to go back.

 

[dimension_join_clause]

JOIN KEY (child_key_column,…) REFERENCES parent_level [JOIN KEY (child_key_column,…) REFERENCES…

 Right Click to go back.

 

[disk_clauses]

{diskgroup_name {add_disk_clause | drop_disk_clauses | resize_disk_clauses} | {diskgroup_name | ALL} undrop_disk_clause}

 Right Click to go back.

 

[diskgroup_alias_clauses]

{ADD ALIAS alias_name FOR filename, alias_name… | DROP ALIAS aliase_name,… | RENAME ALIAS old_alias_name TO new_alias_name, old_...}

 Right Click to go back.

 

[diskgroup_availability]

{MOUNT | DISMOUNT [FORCE | NOFORCE]}

 Right Click to go back.

 

[diskgroup_clauses]

{diskgroup_name {rebalance_diskgroup_clause | check_diskgroup_clauses | diskgroup_template_clauses | diskgroup_directory_clauses | diskgroup_alias_clauses | drop_diskgroup_file_clause} | {diskgroup_name | ALL} diskgroup_availability}

 Right Click to go back.

 

[diskgroup_directory_clauses]

{ADD DIRECTORY filename,… | DROP DIRECTORY filename [FORCE | NOFORCE]]… | RENAME DIRECTORY old_dir_name TO new_dir_name, old_dir_name…

 Right Click to go back.

 

[diskgroup_file_spec]

[‘{fully_qualified_file_name | numeric_file_name | incorporate_file_name | alias_file_name}’][SIZE size_clause][REUSE][autoextend_clause]

 Right Click to go back.

 

[diskgroup_template_clauses]

{{ADD | ALTER} TEMPLATE qualified_template_clause,… | DROP TEMPLATE template_name,…}

 Right Click to go back.

 

[distributed_recov_clauses]

{ENABLE | DISABLE} DISTRIBUTED RECOVERY

 Right Click to go back.

 

[dml_event_clause]

{DELETE | INSERT | UPDATE [OF column,…]}OR {DELETE…}… ON {[schema.]table | [NESTED TABLE nested_table_column OF] [schema.]view} [referencing_clause][FOR EACH ROW]

 Right Click to go back.

 

[dml_table_expression_clause]

{[schema.]{table[{PARTITION (partition) | SUBPARTITION (subpartition)} |@dblink] | {view | materialized view}[@dblink]} | (subquery [subquery_restriction_clause]) | table_collection_exprression}

 Right Click to go back.

 

[domain_index_clause]

INDEXTYPE IS indextype [parallel_clause][PARAMETERS (ODCI_parameters’)]

 Right Click to go back.

 

[drop_binding_clause]

DROP BINDING (parameter_type,…) [FORCE]

 Right Click to go back.

 

[drop_column_clause]

{SET UNUSED {COLUMN (column,…)} [{CASCADE CONSTRAINTS | INVALIDATE} [CASCADE CONSTRAINTS | INVALIDATE]…] | DROP {COLUMN (column,…) ,…)} [{CASCADE CONSTRAINTS | INVALIDATE} [CASCADE CONSTRAINTS | INVALIDATE]…] [CHECKPOINT integer] | DROP {UNUSED COLUMNS | COLUMNS CONTINUE} [CHECKPOINT integer]}

 Right Click to go back.

 

[drop_constraint_clause]

DROP {{PRIMARY KEY | UNIQUE (column,…)}[CASCADE][{KEEP | DROP} INDEX] | CONSTRAINT constraint [CASCADE]}

 Right Click to go back.

 

[drop_disk_clauses]

DROP {DISK disk_name[FORCE | NOFORCE], disk_name… | DISKS IN FAILGROUP failgroup_name [FORCE | NOFORCE], failgroup_name…}

 Right Click to go back.

 

[drop_diskgroup_file_clause]

DROP FILE filename,…

 Right Click to go back.

 

[drop_index_partition]

DROP PARTITION partition_name

 Right Click to go back.

 

[drop_logfile_clauses]

DROP [STANBY] LOGFILE {logfile_descriptor, logfile_descriptor,… | MEMBER ‘filename’,’filename’,…}

 Right Click to go back.

 

[drop_table_partition]

DROP PARTITION partition [update_index_clauses [parallel_clause]]

 Right Click to go back.

 

[drop_table_subpartition]

DROP SUBPARTITION subpartition [update_index_clauses [parallel_clause]]

 Right Click to go back.

 

[element_spec]

[inheritance_clauses]{subprogram_spec | constructor_spec | map_order_function_spec}… [, pragma_clause]

 Right Click to go back.

 

[else_clause]

ELSE else_expr

 Right Click to go back.

 

[enable_disable_clause]

{ENABLE | DISABLE} [VALIDATE | NOVALIDATE] {UNIQUE (column,…) | PRIMARY KEY | CONSTRAINT}[using_index_clause][exceptions_clause][CASCADE][{KEEP | DROP} INDEX]

 Right Click to go back.

 

[end_session_clauses]

{DISCONNECT SESSION ‘integer1,integer2’ [POST_TRANSACTION] | KILL SESSION ‘integer1, integer2’} [IMMEDIATE]

 Right Click to go back.

 

[estimate_statistics_clause]

ESTIMATE [SYSTEM] STATISTICS [for_clause][SAMPLE integer {ROWS | PERCENT}]

 Right Click to go back.

 

[exceptions_clause]

EXCEPTIONS INTO [schema.]table

 Right Click to go back.

 

[exchange_partition_subpart]

EXCHANGE {PARTITION partition | SUBPARTITION subpartition} WITH TABLE table [{INCLUDING | EXCLUDING} INDEXES] [{WITH | WITHOUT} VALIDATION] [exceptions_clause] [update_index_clauses [parallel_clause]]

 Right Click to go back.

 

[expr]

{simple_expression | compound_expression | case_expression | cursor_expression | datetime_expression | function_expression | interval_expression | object_access_expression | model_expression | type_constructor_expression | variable_expression}

 Right Click to go back.

 

[expression_list]

{(expr,…)

 Right Click to go back.

 

[extended_attribute_clause]

ATTRIBUTE attribute LEVEL level DETERMINES (dependent_column,…) LEVEL…

 Right Click to go back.

 

[extent_management_clause]

EXTENT MANAGEMENT {DICTIONARY | LOCAL [AUTOALLOCATE | UNIFORM [SIZE size_clause]]}

 Right Click to go back.

 

[external_data_properties]

DEFAULT DIRECTORY directory [ACCESS PARAMETERS {(opaque_format_spec) | USING CLOB subquery}} LOCATION ([directory:]’location_specifier’,[directory:]…)

 Right Click to go back.

 

[external_table_clause]

([TYPE access_driver_type] external_data_properties)[REJECT LIMIT {integer | UNLIMITED}]

 Right Click to go back.

 

[file_specification]

{datafile_tempfile_spec | diskgroup_file_spec | redo_log_file_spec}

 Right Click to go back.

 

[finish_clause]

[DISCONNECT [FROM SESSION]] [parallel_clause] FINISH [SKIP [STANDBY LOGFILE]][WAIT | NOWAIT]

 Right Click to go back.

 

[flashback_mode_clause]

FLASHBACK {ON | OFF}

 Right Click to go back.

 

[flashback_query_clause]

[VERSIONS BETWEEN {SCN | TIMESTAMP} {expr | MINVALUE} AND {expr | MAXVALUE}] AS OF {SCN | TIMESTAMP} expr

 Right Click to go back.

 

[for_clause]

{FOR {TABLE | ALL [INDEXED] COLUMNS [SIZE integer] | COLUMNS [SIZE integer] {column | attribute} [SIZE integer]}… | ALL [LOCAL] INDEXES}…

 Right Click to go back.

 

[for_update_clause]

FOR UPDATE [OF[[schema.]{table | view}.]column, [schema.]…

[NOWAIT | WAIT integer]

 Right Click to go back.

 

[full_database_recovery]

[STANDBY] DATABASE [{UNTIL {CANCEL | TIME date | CHANGE integer} | USING BACKUP CONTROLFILE}…

 Right Click to go back.

 

[fully_qualified_file_name]

+diskgroup_name/db_name/file_type/file_type_tag.filenumber.incarnation_number

 Right Click to go back.

 

[function_association]

{FUNCTIONS [schema.]function, [schema.]… | PACKAGES [schema.]package, [schema.]… | TYPES [schema.]type, [schema.]… | INDEXES [schema.]index, [schema.]… | INDEXTYPES [schema.]indextype, [schema.]…} {using_statistics_type | {default_cost_clause,[default_selectivity_clause]}}

 Right Click to go back.

 

[function_declaration]

FUNCTION name (parameter datatype, parameter…) RETURN datatype {IS | AS}{pl/sql_block | call_spec}

 Right Click to go back.

 

[function_spec]

FUNCTION name (parameter datatype, parameter…) return_clause

 Right Click to go back.

 

[general_recovery]

RECOVER [AUTOMATIC][FROM ‘location’]{{full_database_recovery | partial_database_recovery | LOGFILE ‘filename’}[{TEST | ALLOW integer CORRUPTION | parallel_clause}… | CONTINUE [DEFAULT] | CANCEL}

 Right Click to go back.

 

[global_partitioned_index]

GLOBAL PARTITION BY {RANGE (column_list)(index_partitioning_clause) | HASH (column_list) {individual_hash_partitions | hash_partitions_by_quantity}}

 Right Click to go back.

 

[grant_object_privileges]

{{object_privilege | ALL [PRIVILEGES]}(column,…)},… on_object_clause TO grantee_clause [WITH HIERARCHY OPTION][WITH GRANT OPTION]

 Right Click to go back.

 

[grant_system_privileges]

{system_privilege | role | ALL PRIVILEGES},… TO grantee_clause [IDENTIFIED BY password][WITH ADMIN OPTION]

 Right Click to go back.

 

[grantee_clause]

{user | role | PUBLIC},…

 Right Click to go back.

 

[group_by_clause]

GROUP BY {expr | rollup_cube_clause | grouping_sets_clause},… [HAVING condition]

 Right Click to go back.

 

[grouping_expression_list]

expression_list,…

 Right Click to go back.

 

[grouping_sets_clause]

GROUPING SETS ({rollup_cube_clause | grouping_expression_list})

 Right Click to go back.

 

[hash_partitioning]

PARTITION BY HASH (column,…) {individual_hash_partitions | hash_partitions_by_quantity}

 Right Click to go back.

 

[hash_partitions_by_quantity]

PARTITIONS hash_partitions_by_quantity [STORE IN (tablespace,…)] [OVERFLOW STORE IN (tablespace,…)]

 Right Click to go back.

 

[hierarchical_query_clause]

[START WITH condition] CONNECT BY [NOCYCLE] condition

 Right Click to go back.

 

[hierarchy_clause]

HIERARCHY hierarchy (child_level CHILD OF parent_level CHILD OF … [dimension_join_clause])

 Right Click to go back.

 

[implementation_clause]

{ANCILLARY TO [primary_operator (parameter_type,…)]…) | context_clause}

 Right Click to go back.

 

[incomplete_file_name]

+diskgroup_name [(template_time)]

 Right Click to go back.

 

[index_attributes]

{physical_attributes_clause | logging_clause | ONLINE | COMPUTE STATISTICS | TABLESPACE {tablespace | DEFAULT} | key_compression | {SORT | NOSORT} | REVERSE | parallel_clause}…

 Right Click to go back.

 

[index_expr]

{column | column_expression}

 Right Click to go back.

 

[index_org_overflow_clause]

[INCLUDING column_name] OVERFLOW [segment_attributes_clause]

 Right Click to go back.

 

[index_org_table_clause]

{mapping_table_clause | PCTTHRESHOLD integer | key_compression}… [index_org_overflow_clause]

 Right Click to go back.

 

[index_partition_description]

PARTITION [partition {segment_attributes_clause | key_compression}…]

 Right Click to go back.

 

[index_partitioning_clause]

PARTITION [partition] VALUES LESS THAN (value, value,…) [segment_attributes_clause]

 Right Click to go back.

 

[index_properties]

{{global_partitioned_index | local_partitioned_index} | index_attributes}… | domain_index_clause

 Right Click to go back.

 

[index_subpartition_clause]

STORE IN (tablespace, tablespace,…) | (SUBPARTITION [subpartition [TABLESPACE tablespace]], SUBPARTITION…)

 Right Click to go back.

 

[individual_hash_paritions]

(PARTITION partition partitioning_storage_clause, PARTITION…)

 Right Click to go back.

 

[inheritance_clauses]

[[NOT] {OVERRIDING | FINAL | INSTANTIABLE}]…

 Right Click to go back.

 

[inline_constraint]

CONSTRAINT constraint_name {[NOT] NULL | UNIQUE | PRIMARY KEY | references_clause | CHECK (condition)} [constraint_state]

 Right Click to go back.

 

[inline_ref_constraint]

{SCOPE IS [schema.]scope_table | WITH ROWID | [CONSTRAINT constraint_name] references_clause [constraint_state]}

 Right Click to go back.

 

[inner_cross_join_clause]

table_reference {[INNER] JOIN table_reference {ON condition | USING (column, column,…)} | {CROSS | NATURAL [INNER]} JOIN table_reference}

 Right Click to go back.

 

[insert_into_clause]

INTO dml_table_expression_clause [t_alias] [(column,…)]

 Right Click to go back.

 

[integer]

[+|-] digit…

 Right Click to go back.

 

[interval_day_to_second]

INTERVAL ‘{integer | integer time_expr | time_expr}’ {{DAY | HOUR | MINUTE} [(leading_precision)] | SECOND [(leading_precision, fractional_seconds_precision)]}[TO {DAY | HOUR | MINUTE | SECOND [(fractional_seconds_precision)]}]

 Right Click to go back.

 

[interval_year_to_month]

INTERVAL ‘integer [- integer]’{YEAR | MONTH} [(precision)][TO {YEAR | MONTH}]

 Right Click to go back.

 

[into_clause]

INTO [schema.]table

 Right Click to go back.

 

[invoker_rigths_clause]

AUTHID {CURRENT_USER | DEFINER}

 Right Click to go back.

 

[java_declaration]

JAVA NAME ‘string’

 Right Click to go back.

 

[join_clause]

{inner_cross_join_clause | outer_join_clause}

 Right Click to go back.

 

[key_compression]

{COMPRESS [integer] | NOCOMPRESS}

 Right Click to go back.

 

[level_clause]

LEVEL level IS (level_table.level_column,…)

 Right Click to go back.

 

[list_partitioning]

PARTITION BY LIST (column) (PARTITION [partition] list_values_clause table_partition_description, PARTITION …)

 Right Click to go back.

 

[list_values_clause]

VALUES ({value | NULL},…) | DEFAULT

 Right Click to go back.

 

[LOB_parameters]

{TABLESPACE tablespace | {ENABLE | DISABLE} STORAGE IN ROW | storage_clause | CHUNK integer | PCTVERSION integer | RETENTION | FREEPOOLS integer | {CACHE | {NOCACHE | CACHE READS} [logging_clause]}}…

 Right Click to go back.

 

[LOB_partition_storage]

PARTITION partition {LOB_storage_clause | varray_col_properties}… (SUBPARTITION subpartition {LOB_storage_clause | varray_col_properties}…)

 Right Click to go back.

 

[LOB_storage_clause]

LOB {(LOB_item,…) STORE AS (LOB_parameters) | (LOB_item) STORE AS {LOB_segname (LOB_parameters) | LOB_segname | (LOB_parameters)}}

 Right Click to go back.

 

[local_partitioned_index]

LOCAL [on_range_partitioned_table | on_list_partitioned_table | on_hash_partitioned_table | on_comp_parttioned_table]

 Right Click to go back.

 

[logfile_clause]

[GROUP integer]file_specification, GROUP…]

 Right Click to go back.

 

[logfile_clauses]

{{ARCHIVELOG [MANUAL] | NOARCHIVELOG} | [NO] FORCE LOGGING | RENAME FILE ‘filename’,… TO ‘filename’ | CLEAR [UNARCHIVED] LOGFILE logfile_descriptor,… [UNRECOVERABLE DATAFILE] | add_logfile_clauses | drop_logfile_clauses | supplemental_db_logging}

 Right Click to go back.

 

[logfile_descriptor]

{GROUP integer | (‘filename’,…) | ‘filename’}

 Right Click to go back.

 

[logging_clause]

{LOGGING | NOLOGGING}

 Right Click to go back.

 

[main_model]

[MAIN main_model_name] model_column_clauses [cell_reference_options] model_rules_clause

 Right Click to go back.

 

[managed_standby_recovery]

RECOVER MANAGED STANDBY DATABASE [recover_clause | cancel_clause | finish_clause]

 Right Click to go back.

 

[map_order_func_declaration]

{MAP | ORDER} MEMBER function_declaration

 Right Click to go back.

 

[map_order_function_spec]

{MAP | ORDER} MEMBER function_spec

 Right Click to go back.

 

[mapping_table_clauses]

{MAPPING TABLE | NOMAPPING}

 Right Click to go back.

 

[materialized_view_props]

[column_properties][table_partitioning_clauses][CACHE | NOCACHE][parallel_clause][build_clause]

 Right Click to go back.

 

[maximize_standby_db_clause]

SET STANDBY DATABASE TO MAXIMIZE {PROTECTION | AVAILABILITY | PERFORMANCE}

 Right Click to go back.

 

[maxsize_clause]

MAXSIZE {UNLIMITED | size_clause}

 Right Click to go back.

 

[merge_insert_clause]

WHEN NOT MATCHED THEN INSERT [(column,…)] VALUES ({expr,… | DEFAULT}) [where_clause]

 Right Click to go back.

 

[merge_table_partitions]

MERGE PARTITIONS partition_1, partition_2 [INTO partition_spec][update_index_clauses][parallel_clause]

 Right Click to go back.

 

[merge_table_subpartitions]

MERGE SUBPARTITIONS subpart_1, subpart_2 [INTO subpartition_spec][update_index_clauses][parallel_clause]

 Right Click to go back.

 

[merge_update_clause]

WHEN MATCHED THEN UPDATE SET column={expr | DEFAULT}, column… [where_clause][DELETE where_clause]

 Right Click to go back.

 

[model_clause]

MODEL [cell_reference_options][return_rows_clause][reference_model]… main_model

 Right Click to go back.

 

[model_column]

expr [[AS] c_alias]

 Right Click to go back.

 

[model_column_clauses]

[query_partition_clause [c_alias]] DIMENSION BY (model_column,…) MEASURES (model_column,…)

 Right Click to go back.

 

[model_rules_clause]

RULES [UPSERT | UPDATE][{AUTOMATIC | SQUENTIAL} ORDER][ITERATE (number) [UNTIL (condition)]] ([UPDATE | UPSERT] cell_assignment [order_by_clause] = expr)…

 Right Click to go back.

 

[modify_col_properties]

([column [datatype][DEFAULT expr][inline_constraint…][LOB_storage_clause]],…)

 Right Click to go back.

 

[modify_col_substitutable]

COLUMN column [NOT] SUBSTRITUTABLE AT ALL LEVELS [FORCE]

 Right Click to go back.

 

[modify_collection_retrieval]

MODIFY NESTED TABLE collection_item RETURN AS {LOCATOR | VALUE}

 Right Click to go back.

 

[modify_column_clauses]

MODIFY {modify_col_properties | modify_col_substitutable}

 Right Click to go back.

 

[modify_hash_partition]

MODIFY PARTITION partition {partition_attributes | alter_mapping_table_clause | [REBUILD] UNUSABLE LOCAL INDEXES}

 Right Click to go back.

 

[modify_hash_subpartition]

{{allocate_extent_clause | deallocate_unused_clause | shrink_clause | [{LOB LOB_item | VARRAY varray} modify_LOB_parameters]…} | [REBUILD] UNUSABLE LOCAL INDEXES}

 Right Click to go back.

 

[modify_index_default_attrs]

MODIFY DEFAULT ATTRIBUTES [FOR PARTITION partition]{physical_atributes_clause | TABLESPACE {tablespace | DEFAULT} | logging_clause}…

 Right Click to go back.

 

[modify_index_partition]

MODIFY PARTITION partition {deallocate_unused_clause | allocate_extent_clause | physical_attributes_clause | logging_clause | key_compression}… | PARAMETERS (‘ODCI_parameters’) | COALESCE | UPDATE BLOCK REFERENCES | UNUSABLE

 Right Click to go back.

 

[modify_index_subpartition]

MODIFY SUBPARTITION partition {UNUSABLE | allocate_extent_clause | deallocate_unused_clause}

 Right Click to go back.

 

[modify_list_partition]

MODIFY PARTITION partition {partition_attributes | {ADD | DROP} VALUES (partition_value,…) | [REBUILD] UNUSABLE LOCAL INDEXES}

 Right Click to go back.

 

[modify_list_subpartition]

{allocate_extent_clause | deallocate_unused_clause | shrink_clause | ]{LOB LOB_item | VARRAY varray} modify_LOB_parameters]… | [REBUILD] UNUSABLE LOCAL INDEXES | {ADD | DROP} VALUES (value,…)}

 Right Click to go back.

 

[modify_LOB_parameters]

[{storage_clause | PCTVERSION integer | RETENTION | FREEPOOLS integer | REBUILD FREEPOOLS | {CACHE | {NOCACHE | CACHE READS}[logging_clause]} | allocate_extent_clause | deallocate_unused_clause | shrink_clause]…

 Right Click to go back.

 

[modify_LOB_storage_clause]

MODIFY LOB (LOB_item) (modify_LOB_parameters)

 Right Click to go back.

 

[modify_range_partition]

MODIFY PARTITION partition {partition_attributes | {add_hash_subpartition | add_list_subpartition} | COALESCE SUBPARTITION [update_index_clauses][parallel_clause] | alter_mapping_table_clause | [REBUILD] UNUSABLE LOCAL INDEXES}

 Right Click to go back.

 

[modify_table_default_attrs]

MODIFY DEFAULT ATTRIBUTES [FOR PARTITION partition] [segment_attributes_clause] [table_compression] [PCTTHRESHOLD integer] [key_compression] [alter_overflow_clause] [{LOB (LOB_item) | VARRAY varrary} (LOB_parameters)]…]

 Right Click to go back.

 

[modify_table_partition]

{modify_range_partition | modify_hash_partition | modify_list_partition}

 Right Click to go back.

 

[modify_table_subpartition]

{modify_range_partition | modify_hash_subpartition | modify_list_subpartition}

 Right Click to go back.

 

[move_table_clause]

MOVE [ONLINE] [segment_attributes_clause] [table_compression] [index_org_table_clause] {LOB_storage_clause | varrary_col_properties}… [parallel_clause]

 Right Click to go back.

 

[move_table_partition]

MOVE PARTITION partition [MAPPING TABLE] [table_partition_description] [update_index_clauses] [parallel_clause]

 Right Click to go back.

 

[move_table_subpartition]

MOVE SUBPARTITION subpartition_spec [update_index_clauses] [parallel_clause]

 Right Click to go back.

 

[multi_column_for_loop]

FOR (dimension_column,…)  IN ((literal,…)(literal,…)…) | subquery

 Right Click to go back.

 

[multi_table_insert]

{ALL [insert_into_clause [values_clause]]… | conditional_insert_clause} subquery

 Right Click to go back.

 

[multiset_except]

nested_table1 MULTISET EXCEPT [ALL | DISTINCT] nested_table2

 Right Click to go back.

 

[multiset_interset]

nested_table1 MULTISET INTERSECT [ALL | DISTINCT] nested_table2

 Right Click to go back.

 

[multiset_union]

nested_table1 MULTISET UNION [ALL | DISTINCT] nested_table2

 Right Click to go back.

 

[nested_table_col_properties]

NESTED TABLE {nested_item | COLUMN_VALUE} [substritutable_column_clause] STORE AS storage_table [((object_properties) | [physical_properties] | [column_properties]]…)] [RETURN AS {LOCATOR | VALUE}]

 Right Click to go back.

 

[new_values_clause]

{INCLUDING | EXCLUDING} NEW VALUES

 Right Click to go back.

 

[number]

[+ | -] {digit…[.]digit… |  [e[+ | -] digit…]  |  [f | d]

 Right Click to go back.

 

[numeric_file_name]

+diskgroup_name.filenumber.incarnation_number

 Right Click to go back.

 

[object_properties]

{column | attribute} [DEFAULT expr] [inline_constraint [inline_constraint]… | inline_ref_constraint] | {out_of_line_constraint | out_of_line_ref_constraint | supplemental_logging_props}

 Right Click to go back.

 

[object_table]

CREATE [GLOBAL TEMPORARY] TABLE [schema.]table OF [schema.]object_type [object_table_substitution] [(object_properties)] [ON COMMIT {DELETE | PRESERVE} ROWS] [OID_clause] [OID_index_clause] [physical_properties] [table_properties];

 Right Click to go back.

 

[object_table_substitution]

[NOT] SUBSTITUTABLE AT ALL LEVELS

 Right Click to go back.

 

[object_type_col_properties]

COLUMN column substitutable_column_clause

 Right Click to go back.

 

[object_view_clause]

OF [schema.]type_name {WITH OBJECT IDENTIFIER {DEFAULT | (attribute,…) | UNDER [schema.]superview} ({out_of_line_constraint | attribute inline_constraint…}…)

 Right Click to go back.

 

[OID_clause]

OBJECT IDENTIFIER IS {SYSTEM GENERATED | PRIMARY KEY}

 Right Click to go back.

 

[OID_index_clause]

OIDINDEX [index] ({physical_attributes_clause | TABLESPACE tablespace}…)

 Right Click to go back.

 

[on_comp_partitioned_table]

[STORE IN (tablespace,…)] (PARTITION [partition {segment_attribute_clause | key_compression}…] [index_subpartition_clause], PARTITION…)

 Right Click to go back.

 

[on_hash_partitioned_table]

STORE IN (tablespace,…) | (PARTITION [partition [TABLESPACE tablespace]],  PARTITION…)

 Right Click to go back.

 

[on_list_partitioned_table]

(PARTITION [partition {segment_attribute_clause | key_compression}…], PARTITION…)

 Right Click to go back.

 

[on_object_clause]

{schema.object | {DIRECTORY directory_name | JAVA {SOURCE | RESOURCE} [schema.]object}}

 Right Click to go back.

 

[on_range_partitioned_table]

(PARTITION [partition {segment_attribute_clause | key_compression}…], PARTITION…)

 Right Click to go back.

 

[order_by_clause]

ORDER [SIBLINGS] BY {expr | position | c_alias} [ASC | DESC] [NULLS FIRST | NULLS LAST], expr…}

 Right Click to go back.

 

[out_of_line_constraint]

[CONSTRAINT constraint_name] {UNIQUE (column,…) | PRIMARY KEY (column,…) | FOREIGN KEY (column,…) references_clause | CHECK (condition)} [constraint_state]

 Right Click to go back.

 

[out_of_line_ref_constraint]

{SCOPE FOR ({ref_col | ref_attr}) IS [schema.]scope_table | REF ({ref_col | ref_attr}) WITH ROWID | [CONSTRAINT constraint_name] FOREIGN KEY ({ref_col | ref_attr}) references_clause [constraint_state]}

 Right Click to go back.

 

[outer_join_clause]

table_reference [query_partition_clause] {outer_join_type JOIN | NATURAL [outer_join_type] JOIN} table_reference [query_partition_clause] [ON condition | USING (column,…)]

 Right Click to go back.

 

[outer_join_type]

{FULL | LEFT | RIGHT} [OUTER]

 Right Click to go back.

 

[parallel_clause]

{NOPARALLEL | PARALLEL [integer] }

 Right Click to go back.

 

[parallel_enable_clause]

PARALLEL_ENABLE [(PARTITION argument BY {ANY | {HASH | RANGE} (column,…)}) [streaming_clause]]

 Right Click to go back.

 

[partial_database_recovery]

{TABLESPACE tablespace,… | DATAFILE {‘filename’ | ‘filenumber, …} | STANBY {TABLESPACE tablespace,… | DATAFILE {‘filename’ | ‘filenumber, …} UNTIL [CONSISTENT WITH] CONTROLFILE}

 Right Click to go back.

 

[partition_attributes]

[{physical_attributes_clause | logging_clause | allocate_extent_clause | deallocate_unused_clause | shrink_clause }…] OVERFLOW [{physical_attributes_clause | logging_clause | allocate_extent_clause | deallocate_unused_clause}…] [table_compression] [{LOB LOB_item | VARRAY varray} modify_LOB_parameters LOB LOB_item…]

 Right Click to go back.

 

[partition_extended_name]

[schema.]{table | view} [PARTITION (partition) | SUBPARTITION (subpartition)]

 Right Click to go back.

 

[partition_level_subpartition]

{SUBPARTITIONS hash_subpartition_quantity [STORE IN (tablespace,…)] | (subpartition_spec,…)}

 Right Click to go back.

 

[partition_spec]

PARTITION [partition] [table_partition_description]

 Right Click to go back.

 

[partitioning_storage_clause]

[{TABLESPACE tablespace | OVERFLOW [TABLESPACE tablespace] | LOB (LOB_item) STORE AS {LOB_segname [(TABLESPACE tablespace)] | (TABLESPACE tablespace} | VARRAY varray_item STORE AS LOB LOB_segment}…]

 Right Click to go back.

 

[password_parameters]

{{FAILED_LOGIN_ATTEMPTS | PASSWORD_LIFE_TIME | PASSWORD_REUSE_TIME | PASSWORD_LOCK_TIME | PASSWORD_GRACE_TIME} {expr | UNLIMITED | DEFAULT} | PASSWORD_VERIFY_FUNCTION {function | NULL | DEFAULT}}

 Right Click to go back.

 

[permanent_tablespace_clause]

{MINIMUM EXTENT integer [K | M] | BLOCKSIZE integer [K] | logging_clause | FORCE LOGGING | DEFAULT [table_compression] storage_clause | {ONLINE | OFFLINE} | extent_management_clause | segment_management_clause | flashback_mode_clause}…

 Right Click to go back.

 

[physical_attributes_clause]

{PCT integer | PCTUSED integer | INITRANS integer | storage_clause}…

 Right Click to go back.

 

[physical_properties]

{segment_attributes_clause [table_compression] | ORGANIZATION {HEAP [segment_attributes_clause] [table_compression] | INDEX [segment_attributes_clause] index_org_table_clause | EXTERNAL external_table_clause} | CLUSTER cluster (column,…)}

 Right Click to go back.

 

[pragma_clause]

PRAGMA RESTRICT_REFERENCES ({method_name | DEFAULT}, {RNDS | WNDS | RNPS | WNPS | TRUST},…)

 Right Click to go back.

 

[procedure_declaration]

PROCEDURE name (parameter datatype, …) {IS | AS} {pl/sql_block | call_spec}

 Right Click to go back.

 

[procedure_spec]

PROCEDURE name (parameter datatype, …) {IS | AS} {call_spec}

 Right Click to go back.

 

[proxy_authentication]

{AUTHENTICATION REQUIRED | AUTHENTICATED USING {PASSWORD | DISTINGUISHED NAME | CERTIFICATE [TYPE ‘type’] [VERSION ‘version’]}}

 Right Click to go back.

 

[proxy_clause]

{GRANT | REVOKE} CONNECT THROUGH proxy [WITH ROLE role_name,… | ALL EXCEPT role_name, … | NO ROLES] [proxy_authentication]

 Right Click to go back.

 

[qualified_disk_clause]

search_string [NAME disk_name] [SIZE size_clause] [FORCE | NOFORCE]

 Right Click to go back.

 

[qualified_template_clause]

template_name ATTRIBUTE ([MIRROR | UNPROTECTED] [FINE | COASE])

 Right Click to go back.

 

[query_partition_clause]

PARTITION BY (value_expr,…)

 Right Click to go back.

 

[query_table_expression]

{query_name | [schema.]table {PARTITION (partition) | SUBPARTITION (subpartition)} | sample_clause | @dblink | {view | materialized view} [@dblink] | (subquery [subquery_restriction_clause]) | table_collection_expression}

 Right Click to go back.

 

[quiesce_clauses]

QUIESCE RESRICTED | UNQUIESCE

 Right Click to go back.

 

[range_partitioning]

PARTITION BY RANGE (column,…) (PARTITION [partition] range_values_clause table_partition_description, PARTITION…)

 Right Click to go back.

 

[range_values_clause]

VALUES LESS THAN ({value | MAXVALUE},…)

 Right Click to go back.

 

[rebalance_diskgroup_clause]

REBALANCE [POWER integer]

 Right Click to go back.

 

[rebuild_clause]

REBUILD [{PARTITION partition | SUBPARTITION subpartition} | {REVERSE | NOREVERSE}]  [parallel_clause | TABLESPACE tablespace | PARAMETERS (‘ODCI_parameters’) | ONLINE | COMPUTE STATISTICS | physical_attributes_clause | key_compression | logging_clause]…

 Right Click to go back.

 

[records_per_block_clause]

{MINIMIZE | NOMINIMIZE} RECORDS_PER_BLOCK

 Right Click to go back.

 

[recover_clause]

{{DISCONNECT [FROM SESSION] | {TIMEOUT integer | NOTIMEOUT}} | {NODELAY | DEFAULT DELAY | DELAY integer} | NEXT integer | {EXPIRE integer | NO EXPIRE} | parallel_clause | USING CURRENT LOGFILE | UNTIL CHANGE integer | THROUGH { [THREAD integer] SEQUENCE integer | ALL ARCHIVELOG | {ALL | LAST | NEXT} SWITCHOVER}}…

 Right Click to go back.

 

[recovery_clauses]

{general_recovery | managed_standby_recovery | BEGIN BACKUP | END BACKUP}

 Right Click to go back.

 

[redo_log_file_spec]

(‘filename’,…) [SIZE size_clause] [REUSE]

 Right Click to go back.

 

[redo_thread_cluasues]

{ENABLE | DISABLE} {INSTANCE ‘instance_name’ | [PUBLIC] THREAD integer}

 Right Click to go back.

 

[reference_model]

REFERENCE reference_spreadsheet_name ON (subquery) spreadsheet_column_clauses [cell_refference_options]

 Right Click to go back.

 

[references_clause]

REFERENCES [schema.]{object_table | view} [(column,…)] [ON DELETE {CASCADE | SET NULL}] [constraint_state]

 Right Click to go back.

 

[referencing_clause]

REFERENCING {OLD [AS] old | NEW [AS] new | PARENT [AS] parent}…

 Right Click to go back.

 

[register_logfile_clause]

REGISTER [OR REPLACE] [PHYSICAL | LOGICAL] LOGFILE [file_specification,…] FOR logminer_session_name

 Right Click to go back.

 

[relational_properties]

{column datatype [SORT] [DEFAULT expr] [inline_constraint … | inline_ref_constraint] | {out_of_line_constraint | out_of_line_ref_constraint | supplemental_logging_props}}…

 Right Click to go back.

 

[relational_table]

CREATE [GLOBAL TEMPORARY] TABLE [schema.]table [(relational_properties)][ON COMMIT {DELETE | PRESERVE} ROWS] [physical_properties] [table_properties];

 Right Click to go back.

 

[rename_column_clause]

RENAME COLUMN old_name TO new_name

 Right Click to go back.

 

[rename_index_partition]

RENAME {PARTITION partition | SUBPARTITION subpartition} TO new_name

 Right Click to go back.

 

[rename_partition_subpart]

RENAME {PARTITION | SUBPARTITION} current_name TO new_name

 Right Click to go back.

 

[replace_type_clause]

REPLACE [invoker_rights_clause] AS OBJECT (attribute datatype,…,element_spec,…)

 Right Click to go back.

 

[resize_disk_clauses]

RESIZE {ALL [SIZE size_clause] | DISK disk_name [SIZE size_clause], disk_name… | DISKS IN FAILGROUP failgroup_name [SIZE size_clause], failegroup…}

 Right Click to go back.

 

[resource_parameters]

{SESSIONS_PER_USER | CPU_PER_SESSION | CPU_PER_CALL | CONNECT_TIME | IDLE_TIME | LOGICAL_READS_PER_SESSION | LOGICAL_READS_PER_CALL | COMPOSITE_LIMIT}{integer | UNLIMITED | DEFAULT} | PRIVATE_SGA {integer [K | M] | UNLIMITED | DEFAULT}

 Right Click to go back.

 

[restricted_session_clauses]

{ENABLE | DISABLE} RESTRICTED SESSION

 Right Click to go back.

 

[return_clause]

{RETURN datatype [{IS | AS} call_spec] | sqlj_object_type_sig}

 Right Click to go back.

 

[return_rows_clause]

RETURN {UPDATED | ALL} ROWS

 Right Click to go back.

 

[returning_clause]

RETURNING expr,… INTO data_item,…

 Right Click to go back.

 

[revoke_object_privileges]

{object_privilege | ALL [PRIVILEGES]},… on_object_clause FROM grantee_clause [CASCADE CONSTRAINTS | FORCE]

 Right Click to go back.

 

[revoke_system_privileges]

{system_privilege | role | ALL PRIVILEGES},… FROM grantee_clause

 Right Click to go back.

 

[rollup_cube_clause]

{ROLLUP | CUBE} (grouping_expression_list)

 Right Click to go back.

 

[routine_clause]

[schema.][type. | package.] {function | procedure | method} [@dblink_name] (argument,…)

 Right Click to go back.

 

[row_movement_clause]

{ENABLE | DISABLE} ROW MOVEMENT

 Right Click to go back.

 

[sample_clause]

SAMPLE [BLOCK] (sample_percent) [SEED (seed_value)]

 Right Click to go back.

 

[schema_object_clause]

{object_option,… | ALL} auditing_on_clause

 Right Click to go back.

 

[scoped_table_ref_constraint]

{SCOPE FOR ({ref_column | ref_attribute}) IS [schema.] {scope_table_name | c_alias}},…

 Right Click to go back.

 

[searched_case_expression]

WHEN condition THEN return_expr WHEN…

 Right Click to go back.

 

[security_clause]

GUARD {ALL | STANDBY | NONE}

 Right Click to go back.

 

[segment_attributes_clause]

{physical_attributes_clause | TABLESPACE tablespace | logging_clause}…

 Right Click to go back.

 

[segment_management_clause]

SEGMENT SPACE MANAGEMENT {MANUAL | AUTO}

 Right Click to go back.

 

[select_list]

* | {query_name.* | [schema.]{table | view | materialized_view}.* | expr [AS] c_alias | {query_name…

 Right Click to go back.

 

[set_subpartition_template]

SET SUBPARTITION TEMPLATE (SUBPARTITION subpartition [list_values_clause] [partitioning_storage_clause], SUBPARTITION …) | hash_subpartition_quantity

 Right Click to go back.

 

[set_time_zone_clause]

SET TIME_ZONE ‘{ {+ | -} hh:mi | time_zone_region}’

 Right Click to go back.

 

[shrink_clause]

SHRINK SPACE [COMPACT] [CASCADE]

 Right Click to go back.

 

[shutdown_dispatcher_clause]

SHUTDOWN [IMMEDIATE] dispatcher_name

 Right Click to go back.

 

[simple_case_expression]

expr WHEN comparison_expr THEN return_expr WHEN…

 Right Click to go back.

 

[single_column_for_loop]

FOR dimension_column {IN ({literal,… | subquery}) | [LIKE pattern] FROM literal TO literal {INCREMENT | DECREMENT} literal}

 Right Click to go back.

 

[single_table_insert]

insert_into_clause {values_clause [returning_clause] | subquery}

 Right Click to go back.

 

[size_clause]

integer [K | M | G | T]

 Right Click to go back.

 

[split_index_partition]

SPLIT PARTITION partition_name_old AT (value,…) INTO (index_partition_description,…) [parallel_clause] UPDATE MANUALLY problem importing file

 Right Click to go back.

 

[split_table_partition]

SPLIT PARTITION current_partition {AT | VALUES} (value,…) INTO (partition_spec,…) [update_index_clauses] [parallel_clause] UPDATE MANUALLY problem importing file

 Right Click to go back.

 

[split_table_subpartition]

SPLIT SUBPARTITION subpartition VALUES ({value | NULL},...) [INTO (subpartition_spec,…) [update_index_clauses] [parallel_clause] UPDATE MANUALLY problem importing file

 Right Click to go back.

 

[sql_statement_clause]

{statement_option | ALL},… | {system_privilege | ALL PRIVILEGES},… [auditing_by_clause]

 Right Click to go back.

 

[sqlj_object_type]

EXTERNAL NAME java_ext_name LANGUAGE JAVA USING (SQLData | CustomDatum | OraData)

 Right Click to go back.

 

[sqlj_object_type_attr]

EXTERNAL NAME ‘field_name’

 Right Click to go back.

 

[sqlj_object_type_sig]

RETURN {datatype | SELF AS RESULT} EXTERNAL {VARIABLE NAME ‘java_static_field_name’ | NAME ‘java_method_sig’}

 Right Click to go back.

 

[standby_database_clauses]

(activate_standby_db_clause | maximize_standby_db_clause | register_logfile_clause | commit_suitchover_clause | start_standby_clause | stop_standby_clause) [parallel_clause]

 Right Click to go back.

 

[start_standby_clause]

START LOGICAL STANDBY APPLY [IMMEDIATE] [NODELAY] [NEW PRIMARY dblink | INITIAL [scn_value] | {SKIP FAILED TRANSACTION | FINISH}]

 Right Click to go back.

 

[startup_clauses]

{MOUNT [{STANDBY | CLONE} DATABASE] | OPEN {[READ WRITE] [RESETLOGS | NORESETLOGS] [UPGRADE | DOWNGRADE] | READ ONLY}}

 Right Click to go back.

 

[stop_standy_clause]

{STOP | ABORT} LOGICAL STANDBY APPLY

 Right Click to go back.

 

[storage_clause]

STORAGE ({INITIAL integer [K | M] | NEXT integer [K | M] | MINEXTENTS integer | MAXEXTENTS {integer | UNLIMITED} | PCTINCREASE integer | FREELISTS integer | FREELIST GROUPS integer | OPTIMAL [integer [K | M] | NULL] | BUFFER_POOL {KEEP | RECYCLE | DEFAULT}…

 Right Click to go back.

 

[streaming_clause]

{ORDER | CLUSTER} BY (column,…)

 Right Click to go back.

 

[subpartition_by_hash]

SUBPARTITION BY HASH (column,…) [SUBPARTITIONS quantity [STORE IN (tablespace,…) | subpartition_template]

 Right Click to go back.

 

[subpartition_by_list]

SUBPARTITION BY LIST (column) [subpartition_template]

 Right Click to go back.

 

[subpartition_spec]

SUBPARTITION [subpartition] [list_valuses_clause] [partitioning_storage_clause]

 Right Click to go back.

 

[subpartition_template]

SUBPARTITION TEMPLATE (SUBPARTITION subpartition [list_valuses_clause] [partitioning_storage_clause], SUBPARTITION subparition…) | hash_subpartition_quantity

 Right Click to go back.

 

[subprogram_declaration]

{MEMBER | STATIC} {procedure_declaration | function_declaration | constructor_declaration}

 Right Click to go back.

 

[subprogram_spec]

{MEMBER | STATIC} {procedure_spec | function_spec}

 Right Click to go back.

 

[subquery]

[subquery_factoring_clause] SELECT [hint] [{{DISTINCT | UNIQUE} | ALL}] select_list FROM table_reference, … [where_clause] [hierarchical_query_clause] [group_by_clause] [HAVING condition] [model_clause] [{UNION [ALL] | INTERSECT | MINUS} {subquery)][order_by_clause]

 Right Click to go back.

 

[subquery_factoring_clause]

WITH query_name AS (subquery), query_name…

 Right Click to go back.

 

[subquery_restriction_clause]

WITH {READ ONLY | CHECK OPTION [CONSTRAINT constraint]}

 Right Click to go back.

 

[substitutable_column_clause]

[ELEMENT] IS OF [TYPE] ([ONLY] type) | [NOT] SUBSTITUTABLE AT ALL LEVELS

 Right Click to go back.

 

[supplemental_db_logging]

{ADD | DROP} SUPPLEMENTAL LOG {DATA | supplemental_id_key_clause}

 Right Click to go back.

 

[supplemental_id_key_clause]

DATA ({ALL | PRIMARY KEY | UNIQUE | FOREIGN KEY},…) COLUMNS

 Right Click to go back.

 

[supplemental_log_grp_clause]

GROUP log_group (column [NO LOG], column…) [ALWAYS]

 Right Click to go back.

 

[supplemental_logging_props]

{supplemental_log_grp_clause | supplemental_id_key_clause}

 Right Click to go back.

 

[supplemental_table_logging]

ADD SUPPLEMENTAL LOG {supplemental_log_grp_clause }, SUPPLEMENTAL LOG… | DROP SUPPLEMENTAL LOG {supplemental_id_key_clause | GROUP log_group}, SUPPLEMENTAL LOG…

 Right Click to go back.

 

[table_collection_expression]

TABLE (collection_expression) [(+)]

 Right Click to go back.

 

[table_compression]

{COMPRESS | NOCOMPRESS}

 Right Click to go back.

 

[table_index_clause]

[schema.]table [t_alias] (index_expr [ASC | DESC], index_expr…) [index_properties]

 Right Click to go back.

 

[table_partition_description]

[segment_attributes_clause] [table_compression | key_compression] [OVERFLOW [segment_attributes_clause]] [{LOB_storage_clause | varray_col_properties}…] [partition_level_subpartition]

 Right Click to go back.

 

[table_partitioning_clauses]

{range_partitioning | hash_partitioning | list_partitioning | composite_partitioning}

 Right Click to go back.

 

[table_properties]

[column_properties] [table_partitioning_clauses] [CACHE | NOCACHE] [parallel_clause] [ROWDEPENDENCIES | NOROWDEPENDENCIES] [enable_disable_clause]  [row_movement_clause] [AS subquery]

 Right Click to go back.

 

[table_reference]

ONLY (query_table_expression) [flashback_query_clause] [t_alias] | (join_clause)

 Right Click to go back.

 

[tablespace_clauses]

EXTENT MANGEMENT LOCAL | DATAFILE file_specification,… | SYSAUX DATAFILE file_specification,… | default_tablespace | default_temp_tablespace | undo_tablespace

 Right Click to go back.

 

[tablespace_group_clause]

TABLESPACE GROUP {tablespace_group_name | ‘’}

 Right Click to go back.

 

[tablespace_logging_clauses]

{logging_clause | [NO] FORCE LOGGING}

 Right Click to go back.

 

[tablespace_retention_clause]

RETENTION {GUARANTEE | NOGUARANTEE}

 Right Click to go back.

 

[tablespace_state_clauses]

{ONLINE | OFFLINE [NORMAL | TEMPORARY | IMMEDIATE]} | READ {ONLY | WRITE} | {PERMANENT | TEMPORARY}

 Right Click to go back.

 

[temporary_tablespace_clause]

TEMPORARY TABLESPACE tablespace [TEMPFILE file_specification,…] [tablespace_group_clause] [extent_management_clause]

 Right Click to go back.

 

[text]

[N | n] {‘c…’ | {Q | q} ‘c…’}

 Right Click to go back.

 

[trace_file_clause]

TRACE [AS ‘filename’ [REUSE]] [RESETLOGS | NORESETLOGS]

 Right Click to go back.

 

[truncate_partition_subpart]

TRUNCATE {PARTITION partition | SUBPARTITION subpartition} [{DROP | REUSE] STORAGE] [update_index_clauses [parallel_clause]]

 Right Click to go back.

 

[undo_tablespace]

[BIGFILE | SMALLFILE] UNDO TABLESPACE tablespace [TABLESPACE file_specification,…]

 Right Click to go back.

 

[undo_tablesapce_clause]

UNDO TABLESPACE tablespace [DATAFILE file_specification,…] [extent_management_clause] [tablespace_retention_clause]

 Right Click to go back.

 

[undrop_disk_clause]

UNDROP DISKS

 Right Click to go back.

 

[update_all_indexes_clause]

UPDATE INDEXES [(index ({update_index_partition | update_index_subpartition}),index…))]…

 Right Click to go back.

 

[update_global_index_clause]

{UPDATE | INVALIDATE} GLOBAL INDEXES

 Right Click to go back.

 

[update_index_clauses]

{update_global_index_clause | update_all_indexes_clause}

 Right Click to go back.

 

[update_index_partition]

PARTITION [partition] [index_partition_description [index_subpartition_clause]], PARTITION…

 Right Click to go back.

 

[update_index_subpartition]

SUBPARTITION [subpartition] [TABLESPACE tablespace], SUBPARTITION…

 Right Click to go back.

 

[update_set_clause]

SET {(column,…) = (subquery) | column = {expr | (subquery) | DEFAULT}},… | VALUE (t_alias) = {expr | (subquery)}

 Right Click to go back.

 

[upgrade_table_clause]

UPGRADE [[NOT] INCLUDING DATA] [column_properties]

 Right Click to go back.

 

[using_function_clause]

USING [schema.][package. | type.]function_name

 Right Click to go back.

 

[using_index_clause]

USING INDEX {[schema.]index | (create_index_statement) | index_properties}

 Right Click to go back.

 

[using_statistics_type]

USING {[schema.]statistics_type | NULL}

 Right Click to go back.

 

[using_type_clause]

USING [schema.]implementation_type [array_DML_clause]

 Right Click to go back.

 

[validation_clauses]

{VALIDATE REF UPDATE [SET DANGLING TO NULL] | VALIDATE STRUCTURE [CASCADE] [into_clause] {OFFLINE | ONLINE}}

 Right Click to go back.

 

[values_clause]

VALUES ({expr | DEFAULT},…)

 Right Click to go back.

 

[varrary_col_properties]

VARRAY varray_item [substitutable_column_clause] STORE AS LOB LOB_segname (LOB_parameters) | substitutable_column_clause

 Right Click to go back.

 

[where_clause]

WHERE condition

 Right Click to go back.

 

[windowing_clause]

{ROWS | RANGE} {BETWEEN {UNBOUNDED PRECEDING | CURRENT ROW | value_expr {PRECEDING | FOLLOWING}} AND {UNBOUNDED FOLLOWING | CURRENT ROW | value_expr {PRECEDING | FOLLOWING}}

 Right Click to go back.

 

[XML_attributes_clause]

XMLATTRIBUTES (value_expr [AS c_alias],value_expr…)

 Right Click to go back.

 

[XMLSchema_spec]

[XMLSCHEMA XMLSchema_URL] ELEMENT {element | XMLSchema_URL # element}

 Right Click to go back.

 

[XMLType_column_properties]

XMLTYPE [COLUMN] column [XMLType_storage] [XMLSchema_spec]

 Right Click to go back.

 

[XMLType_storage]

STORE AS {OBJECT RELATIONAL} | CLOB LOB_segname (LOB_parameters) | LOB_parameters

 Right Click to go back.

 

[XMLType_table]

CREATE TABLE [GLOBAL TEMPORARY] TABLE [schema.]table OF XMLTYPE [(object_properties)] [XMLTYPE XMLType_storage] [XMLSchema_spec] [ON COMMIT {DELETE | PRESERVE} ROWS] [OID_clause] [OID_index_clause] [physical_properties] [table_properties]

 Right Click to go back.

 

[XMLType_view_clause]

OF XMLTYPE [XMLSchema_spec] WITH OBJECT IDENTIFIER {DEFAULT | (expr,…)}

 Right Click to go back.

 

Google
 
Web web site