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.