iSelfSchooling - Oracle ALL

{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

[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

[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]

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]

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]

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.