Index
A B C D E F G H I J K L M N O P Q R S T U V W X
Symbols
- - (dash)
-
- datetime format element, 7.1.2
- . (period)
-
- datetime format element, 7.1.2
- /(slash)
-
- datetime format element, 7.1.2
- SQL*Plus command, A.1
- , (comma)
-
- datetime format element, 7.1.2
- : (colon)
-
- datetime format element, 7.1.2
- ; (semicolon)
-
- datetime format element, 7.1.2
- @ (at sign)
-
- SQL*Plus command, A.1
A
- ABS function, 2.1
- ACOS function, 2.1
- activate_standby_db_clause, 5.1
- add_binding_clause, 5.1
- add_columns_clause, 5.1
- add_disk_clause, 5.1
- add_hash_index_partition, 5.1
- add_hash_partition_clause, 5.1
- add_hash_subpartition, 5.1
- add_list_partition_clause, 5.1
- add_list_subpartition, 5.1
- add_logfile_clauses, 5.1
- ADD_MONTHS function, 2.1
- add_overflow_clause, 5.1
- add_range_partition_clause, 5.1
- add_table_partition, 5.1
- alias_file_name, 5.1
- allocate_extent_clause, 5.1
- ALTER CLUSTER statement, 1.1
- ALTER DATABASE statement, 1.1
- ALTER DIMENSION statement, 1.1
- ALTER DISKGROUP statement, 1.1
- ALTER FUNCTION statement, 1.1
- ALTER INDEX statement, 1.1
- ALTER INDEXTYPE statement, 1.1
- ALTER JAVA statement, 1.1
- ALTER MATERIALIZED VIEW LOG statement, 1.1
- ALTER MATERIALIZED VIEW statement, 1.1
- ALTER OPERATOR statement, 1.1
- ALTER OUTLINE statement, 1.1
- ALTER PACKAGE statement, 1.1
- ALTER PROCEDURE statement, 1.1
- ALTER PROFILE statement, 1.1
- ALTER RESOURCE COST statement, 1.1
- ALTER ROLE statement, 1.1
- ALTER ROLLBACK SEGMENT statement, 1.1
- ALTER SEQUENCE statement, 1.1, 1.1
- ALTER SESSION statement, 1.1
- ALTER SYSTEM statement, 1.1
- ALTER TABLE statement, 1.1
- ALTER TABLESPACE statement, 1.1
- ALTER TRIGGER statement, 1.1
- ALTER TYPE statement, 1.1
- ALTER USER statement, 1.1
- ALTER VIEW statement, 1.1
- alter_attribute_definition, 5.1
- alter_collection_clauses, 5.1
- alter_datafile_clause, 5.1
- alter_external_table_clauses, 5.1
- alter_index_partitioning, 5.1
- alter_iot_clauses, 5.1
- alter_mapping_table_clauses, 5.1
- alter_method_spec, 5.1
- alter_mv_refresh, 5.1
- alter_overflow_clause, 5.1
- alter_session_set_clause, 5.1
- alter_system_reset_clause, 5.1
- alter_system_security_clauses, 5.1
- alter_system_set_clause, 5.1
- alter_table_partitioning, 5.1
- alter_table_properties, 5.1
- alter_tempfile_clause, 5.1
- alter_varray_col_properties, 5.1
- American National Standards Institute (ANSI)
-
- datatypes
-
- conversion to Oracle datatypes, 6.1.3
- analytic functions, 2.1
- analytic_clause, 5.1
- ANALYZE statement, 1.1
- ANSI-supported datatypes, 6.1
- APPEND
-
- SQL*Plus command, A.1
- APPENDCHILDXML function, 2.1
- archive_log_clause, 5.1
- array_DML_clause, 5.1
- ASCII function, 2.1
- ASCIISTR function, 2.1
- ASIN function, 2.1
- ASM_filename, 5.1
- ASSOCIATE STATISTICS statement, 1.1
- ATAN function, 2.1
- ATAN2 function, 2.1
- attribute_clause, 5.1
- AUDIT statement, 1.1
- auditing_by_clause, 5.1
- auditing_on_clause, 5.1
- autoextend_clause, 5.1
- AVG function, 2.1
B
- BFILENAME function, 2.1
- BIN_TO_NUM function, 2.1
- binding_clause, 5.1
- BITAND function, 2.1
- bitmap_join_index_clause, 5.1
- build_clause, 5.1
C
- C_declaration, 5.1
- CALL statement, 1.1
- call_spec, 5.1
- cancel_clause, 5.1
- CARDINALITY function, 2.1
- CASE expressions, 3.1
- CAST function, 2.1
- CC datetime format element, 7.1.2
- CEIL function, 2.1
- cell_assignment, 5.1
- cell_reference_options, 5.1
- CHANGE
-
- SQL*Plus command, A.1
- character_datatypes, 6.1.1
- character_set_clause, 5.1
- CHARTOROWID function, 2.1
- check_datafiles_clause, 5.1
- check_diskgroup_clauses, 5.1
- checkpoint_clause, 5.1
- CHR function, 2.1
- CLUSTER_ID function, 2.1
- cluster_index_clause, 5.1
- CLUSTER_PROBABILITY function, 2.1
- CLUSTER_SET function, 2.1
- COALESCE function, 2.1
- coalesce_index_partition, 5.1
- coalesce_table_partition, 5.1
- COLLECT function, 2.1
- column_association, 5.1
- column_clauses, 5.1
- column_definition, 5.1
- column_properties, 5.1
- COMMENT statement, 1.1
- COMMIT statement, 1.1
- commit_switchover_clause, 5.1
- compile_type_clause, 5.1
- compiler_parameters_clause, 5.1
- COMPOSE function, 2.1
- composite_partitioning, 5.1
- compound conditions, 4.1
- compound expressions, 3.1
- compute_statistics_clause, 5.1
- CONCAT function, 2.1
- conditional_insert_clause, 5.1
- conditions, 4
-
- see also SQL conditions
- CONNECT
-
- SQL*Plus command, A.1
- constraint, 5.1
- constraint_clauses, 5.1
- constraint_state, 5.1
- constructor_declaration, 5.1
- constructor_spec, 5.1
- context_clause, 5.1
- controlfile_clauses, 5.1
- CONVERT function, 2.1
- convert_standby_clause, 5.1
- Converting to Oracle Datatypes, 6.1.3
- CORR function, 2.1
- CORR_K function, 2.1
- CORR_S function, 2.1
- COS function, 2.1
- COSH function, 2.1
- cost_matrix_clause, 5.1
- COUNT function, 2.1
- COVAR_POP function, 2.1
- COVAR_SAMP function, 2.1
- CREATE CLUSTER statement, 1.1
- CREATE CONTEXT statement, 1.1
- CREATE CONTROLFILE statement, 1.1
- CREATE DATABASE LINK statement, 1.1
- CREATE DATABASE statement, 1.1
- CREATE DIMENSION statement, 1.1
- CREATE DIRECTORY statement, 1.1
- CREATE DISKGROUP statement, 1.1
- CREATE FUNCTION statement, 1.1
- CREATE INDEX statement, 1.1
- CREATE INDEXTYPE statement, 1.1
- CREATE JAVA statement, 1.1
- CREATE LIBRARY statement, 1.1
- CREATE MATERIALIZED VIEW LOG statement, 1.1
- CREATE MATERIALIZED VIEW statement, 1.1
- CREATE OPERATOR statement, 1.1
- CREATE OUTLINE statement, 1.1
- CREATE PACKAGE BODY statement, 1.1
- CREATE PACKAGE statement, 1.1
- CREATE PFILE statement, 1.1
- CREATE PROCEDURE statement, 1.1
- CREATE PROFILE statement, 1.1
- CREATE RESTORE POINT statement, 1.1
- CREATE ROLE statement, 1.1
- CREATE ROLLBACK SEGMENT statement, 1.1
- CREATE SCHEMA statement, 1.1, 1.1
- CREATE SEQUENCE statement, 1.1
- CREATE SPFILE statement, 1.1
- CREATE SYNONYM statement, 1.1
- CREATE TABLE statement, 1.1
- CREATE TABLESPACE statement, 1.1
- CREATE TRIGGER statement, 1.1
- CREATE TYPE BODY statement, 1.1
- CREATE TYPE statement, 1.1
- CREATE USER statement, 1.1
- CREATE VIEW statement, 1.1
- create_datafile_clause, 5.1
- create_incomplete_type, 5.1
- create_mv_refresh, 5.1
- create_nested_table_type, 5.1
- create_object_type, 5.1
- create_varray_type, 5.1
- CUME_DIST (aggregate) function, 2.1
- CUME_DIST (analytic) function, 2.1
- currency
-
- group separators, 7.1.1.1
- currency symbol
-
- ISO, 7.1.1.1
- local, 7.1.1.1
- union, 7.1.1.1
- CURRENT_DATE function, 2.1
- CURRENT_TIMESTAMP function, 2.1
- CURSOR expression, 3.1
- CV function, 2.1
D
- database_file_clauses, 5.1
- database_logging_clauses, 5.1
- datafile_tempfile_clauses, 5.1
- datafile_tempfile_spec, 5.1
- date format models, 7.1.2, 7.1.2.1
-
- datetime format elements, 7.1.2
- long, 7.1.2.1
- short, 7.1.2.1
- DATETIME expressions, 3.1
- datetime format elements, 7.1.2
- datetime_datatypes, 6.1.1
- db_user_proxy, 5.1
- DB2 datatypes
-
- restrictions on, 6.1.3, 6.1.3
- dblink, 5.1
- dblink_authentication, 5.1
- DBTIMEZONE function, 2.1
- DD datetime format element, 7.1.2
- DDAY datetime format element, 7.1.2
- DDD datetime format element, 7.1.2
- deallocate_unused_clause, 5.1
- decimal characters
-
- specifying, 7.1.1.1
- DECODE function, 2.1
- DECOMPOSE function, 2.1
- default_cost_clause, 5.1
- default_selectivity_clause, 5.1
- default_settings_clauses, 5.1
- default_tablespace, 5.1
- default_temp_tablespace, 5.1
- DEL
-
- SQL*Plus command, A.1
- DELETE statement, 1.1
- DENSE_RANK (aggregate) function, 2.1, 2.1
- dependent_handling_clause, 5.1
- DEPTH function, 2.1
- DEREF function, 2.1
- DESCRIBE
-
- SQL*Plus command, A.1
- dimension_join_clause, 5.1
- DISASSOCIATE STATISTICS statement, 1.1
- DISCONNECT
-
- SQL*Plus command, A.1
- diskgroup_alias_clauses, 5.1
- diskgroup_availability, 5.1
- diskgroup_directory_clauses, 5.1
- diskgroup_template_clauses, 5.1
- distributed_recov_clauses, 5.1
- dml_event_clause, 5.1
- dml_table_expression_clause, 5.1
- domain_index_clause, 5.1
- DROP CLUSTER statement, 1.1
- DROP CONTEXT statement, 1.1
- DROP DATABASE LINK statement, 1.1
- DROP DATABASE statement, 1.1
- DROP DIMENSION statement, 1.1
- DROP DIRECTORY statement, 1.1
- DROP DISKGROUP statement, 1.1
- DROP FUNCTION statement, 1.1
- DROP INDEX statement, 1.1
- DROP INDEXTYPE statement, 1.1
- DROP JAVA statement, 1.1
- DROP LIBRARY statement, 1.1
- DROP MATERIALIZED VIEW LOG statement, 1.1
- DROP MATERIALIZED VIEW statement, 1.1
- DROP OPERATOR statement, 1.1
- DROP OUTLINE statement, 1.1
- DROP PACKAGE statement, 1.1
- DROP PROCEDURE statement, 1.1
- DROP PROFILE statement, 1.1
- DROP RESTORE POINT statement, 1.1
- DROP ROLE statement, 1.1
- DROP ROLLBACK SEGMENT statement, 1.1
- DROP SEQUENCE statement, 1.1
- DROP SYNONYM statement, 1.1
- DROP TABLE statement, 1.1
- DROP TABLESPACE statement, 1.1
- DROP TRIGGER statement, 1.1
- DROP TYPE BODY statement, 1.1
- DROP TYPE statement, 1.1
- DROP USER statement, 1.1
- DROP VIEW statement, 1.1
- drop_binding_clause, 5.1
- drop_column_clause, 5.1
- drop_constraint_clause, 5.1
- drop_disk_clauses, 5.1
- drop_diskgroup_file_clause, 5.1
- drop_index_partition, 5.1
- drop_logfile_clauses, 5.1
- drop_table_partition, 5.1
- drop_table_subpartition, 5.1
- DUMP function, 2.1
- DY datetime format element, 7.1.2
E
- E datetime format element, 7.1.2
- EDIT
-
- SQL*Plus command, A.1
- EE datetime format element, 7.1.2
- element_spec, 5.1
- else_clause, 5.1
- EMPTY_BLOB function, 2.1, 2.1
- enable_disable_clause, 5.1
- encryption_spec, 5.1
- end_session_clauses, 5.1
- EQUALS_PATH condition, 4.1
- error_logging_clause, 5.1
- estimate_statistics_clause, 5.1
- exceptions_clause, 5.1
- exchange_partition_subpart, 5.1
- EXECUTE
-
- SQL*Plus command, A.1
- EXISTSNODE function, 2.1
- EXIT
-
- SQL*Plus command, A.1
- EXP function, 2.1
- EXPLAIN PLAN statement, 1.1
- expr, 5.1
- expression_list, 5.1
- expressions, 3
-
- see also SQL expressions
- extended_attribute_clause, 5.1
- extent_management_clause, 5.1
- external_data_properties, 5.1
- external_table_clause, 5.1
- EXTRACT (datetime) function, 2.1
- EXTRACT (XML) function, 2.1
- EXTRACTVALUE function, 2.1
F
- FF datetime format element, 7.1.2
- file_specification, 5.1
- finish_clause, 5.1
- FIRST function, 2.1
- FIRST_VALUE function, 2.1, 2.1, 2.1, 2.1
- FLASHBACK DATABASE statement, 1.1
- FLASHBACK TABLE statement, 1.1
- flashback_mode_clause, 5.1
- flashback_query_clause, 5.1
- floating-point condition, 4.1
- FLOOR function, 2.1
- for_clause, 5.1
- for_update_clause, 5.1
- format models, 7.1
-
- date format models, 7.1.2
-
- datetime format elements, 7.1.2
- number format models, 7.1.1
-
- number format elements, 7.1.1.1
- FROM_TZ function, 2.1
- full_database_recovery, 5.1
- fully_qualified_file_name, 5.1
- function_association, 5.1
- function_declaration, 5.1
- function_spec, 5.1
- functions, 2
-
- see also SQL functions
G
- general_recovery, 5.1
- GET
-
- SQL*Plus command, A.1
- global_partitioned_index, 5.1
- GRANT statement, 1.1
- grant_object_privileges, 5.1
- grant_system_privileges, 5.1
- grantee_clause, 5.1
- GRAPHIC datatype
-
- DB2, 6.1.3, 6.1.3
- SQL/DS, 6.1.3, 6.1.3
- GREATEST function, 2.1
- group comparison condition, 4.1
- group separator
-
- specifying, 7.1.1.1
- group_by_clause, 5.1
- GROUP_ID function, 2.1
- GROUPING function, 2.1
- grouping_expression_list, 5.1
- GROUPING_ID function, 2.1
- grouping_sets_clause, 5.1
H
- hash_partitioning, 5.1
- hash_partitions_by_quantity, 5.1
- HELP
-
- SQL*Plus command, A.1
- hexadecimal value
-
- returning, 7.1.1.1
- HEXTORAW function, 2.1
- HH datetime format element, 7.1.2
- hierarchical_query_clause, 5.1
- hierarchy_clause, 5.1
- HOST
-
- SQL*Plus command, A.1
I
- implementation_clause, 5.1
- IN conditions, 4.1, 4.1
- incomplete_file_name, 5.1
- index_attributes, 5.1
- index_expr, 5.1
- index_org_overflow_clause, 5.1
- index_org_table_clause, 5.1
- index_partition_description, 5.1
- index_partitioning_clause, 5.1
- index_properties, 5.1
- index_subpartition_clause, 5.1
- individual_hash_partitions, 5.1
- inheritance_clauses, 5.1
- INITCAP function, 2.1
- inline_constraint, 5.1
- inline_ref_constraint, 5.1
- inner_cross_join_clause, 5.1
- INPUT
-
- SQL*Plus command, A.1
- INSERT statement, 1.1
- insert_into_clause, 5.1
- instance_clauses, 5.1
- INSTR function, 2.1
- integer, 5.1
- INTERVAL expressions, 3.1
- interval_day_to_second, 5.1
- interval_year_to_month, 5.1
- into_clause, 5.1
- invoker_rights_clause, 5.1
- IS A SET conditions, 4.1
- IS ANY condition, 4.1
- IS EMPTY conditions, 4.1
- IS OF TYPE conditions, 4.1
- IS PRESENT condition, 4.1
- ITERATION_NUMBER function, 2.1
J
- Java_declaration, 5.1
- join_clause, 5.1
K
- key_compression, 5.1
L
- LAG function, 2.1
- large_object_datatypes, 6.1.1
- LAST function, 2.1
- LAST_DAY function, 2.1
- LAST_VALUE function, 2.1
- LEAD function, 2.1
- LEAST function, 2.1
- LENGTH function, 2.1
- level_clause, 5.1
- LIKE condition, 4.1
- LIST
-
- SQL*Plus command, A.1
- list_partitioning, 5.1
- list_values_clause, 5.1
- LN function, 2.1
- LNNVL function, 2.1
- LOB_parameters, 5.1
- LOB_partition_storage, 5.1
- LOB_storage_clause, 5.1
- local_partitioned_index, 5.1
- locale independent, 7.1.2.1
- LOCALTIMESTAMP function, 2.1
- LOCK TABLE statement, 1.1
- LOG function, 2.1
- logfile_clause, 5.1
- logfile_clauses, 5.1
- logfile_descriptor, 5.1
- logging_clause, 5.1
- logical conditions, 4.1
- LONG VARGRAPHIC datatype
-
- DB2, 6.1.3, 6.1.3, 6.1.3, 6.1.3
- SQL/DS, 6.1.3, 6.1.3
- long_and_raw_datatypes, 6.1.1
- LOWER function, 2.1
- LPAD function, 2.1
- LTRIM function, 2.1
M
- main_model, 5.1
- MAKE_REF function, 2.1
- managed_standby_recovery, 5.1
- map_order_func_declaration, 5.1
- map_order_function_spec, 5.1
- mapping_table_clauses, 5.1
- materialized_view_props, 5.1
- MAX function, 2.1
- maximize_standby_db_clause, 5.1
- maxsize_clause, 5.1
- MEDIAN function, 2.1
- MEMBER condition, 4.1
- MERGE statement, 1.1
- merge_insert_clause, 5.1
- merge_table_partitions, 5.1
- merge_table_subpartitions, 5.1
- merge_update_clause, 5.1
- MIN function, 2.1
- mining_attribute_clause, 5.1
- MOD function, 2.1
- model expressions, 3.1
- model_clause, 5.1
- model_column, 5.1
- model_column_clauses, 5.1
- model_rules_clause, 5.1
- modify_col_properties, 5.1
- modify_col_substitutable, 5.1
- modify_collection_retrieval, 5.1
- modify_column_clauses, 5.1
- modify_hash_partition, 5.1
- modify_hash_subpartition, 5.1
- modify_index_default_attrs, 5.1
- modify_index_partition, 5.1
- modify_index_subpartition, 5.1
- modify_list_partition, 5.1
- modify_list_subpartition, 5.1
- modify_LOB_parameters, 5.1
- modify_LOB_storage_clause, 5.1
- modify_range_partition, 5.1
- modify_table_default_attrs, 5.1
- modify_table_partition, 5.1
- modify_table_subpartition, 5.1
- MONTHS_BETWEEN function, 2.1
- move_table_clause, 5.1
- move_table_partition, 5.1
- move_table_subpartition, 5.1
- multi_column_for_loop, 5.1
- multi_table_insert, 5.1
- multiset_except, 5.1
- multiset_intersect, 5.1
- multiset_union, 5.1
N
- NANVL function, 2.1
- NCHR function, 2.1
- nested_table_col_properties, 5.1
- NEW_TIME function, 2.1
- NEXT_DAY function, 2.1
- NLS_CHARSET_DECL_LEN function, 2.1
- NLS_CHARSET_ID function, 2.1
- NLS_CHARSET_NAME function, 2.1
- NLS_INITCAP function, 2.1
- NLS_LOWER function, 2.1
- NLS_UPPER function, 2.1
- NLSSORT function, 2.1
- NOAUDIT statement, 1.1
- NTILE function, 2.1
- NULL conditions, 4.1
- NULLIF function, 2.1
- number format elements, 7.1.1.1
- number format models, 7.1.1
-
- number format elements, 7.1.1.1
- number_datatypes, 6.1.1
- NUMTODSINTERVAL function, 2.1
- NUMTOYMINTERVAL function, 2.1
- NVL function, 2.1
- NVL2 function, 2.1
O
- object access expressions, 3.1
- ORA_HASH function, 2.1
- Oracle Built-In Datatypes, 6.1.1
- Oracle built-in datatypes, 6.1
- Oracle-Supplied Datatypes, 6.1.2
- Oracle-supplied datatypes, 6.1
P
- PATH function, 2.1
- PERCENT_RANK (aggregate) function, 2.1
- PERCENT_RANK (analytic) function, 2.1
- PERCENTILE_CONT function, 2.1
- PERCENTILE_DISC function, 2.1
- POWER function, 2.1
- POWERMULTISET function, 2.1
- POWERMULTISET_BY_CARDINALITY function, 2.1
- PRESENTNNV function, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1
- PRESENTV function, 2.1
- PREVIOUS function, 2.1
- PURGE statement, 1.1
Q
- QUIT
-
- SQL*Plus command, A.1
R
- range conditions, 4.1
- RANK (aggregate) function, 2.1
- RANK (analytic) function, 2.1
- RATIO_TO_REPORT function, 2.1
- RAWTOHEX function, 2.1
- RAWTONHEX function, 2.1
- redo_thread_clauses
-
- see instance_clauses
- REF function, 2.1
- REFTOHEX function, 2.1
- REGEXP_INSTR function, 2.1
- REGEXP_LIKE condition, 4.1
- REGEXP_REPLACE function, 2.1
- REGEXP_SUBSTR function, 2.1
- REGR_AVGX function, 2.1
- REGR_AVGY function, 2.1
- REGR_COUNT function, 2.1
- REGR_INTERCEPT function, 2.1
- REGR_R2 function, 2.1
- REGR_SLOPE function, 2.1
- REGR_SXX function, 2.1
- REGR_SXY function, 2.1
- REGR_SYY function, 2.1
- REMAINDER function, 2.1
- RENAME statement, 1.1
- REPLACE function, 2.1
- REVOKE statement, 1.1
- ROLLBACK statement, 1.1
- ROUND (date) function, 2.1
- ROUND (number) function, 2.1
- ROW_NUMBER function, 2.1
- rowid_datatypes, 6.1.1
- ROWIDTOCHAR function, 2.1
- ROWTONCHAR function, 2.1
- RPAD function, 2.1
- RTRIM function, 2.1
- RUN
-
- SQL*Plus command, A.1
S
- SAVE
-
- SQL*Plus command, A.1
- SAVEPOINT statement, 1.1
- scalar subquery expression, 3.1
- SCC datetime format element, 7.1.2
- scientific notation, 7.1.1.1
- SCN_TO_TIMESTAMP function, 2.1
- SELECT statement, 1.1
- SESSIONTIMEZONE function, 2.1
- SET
-
- SQL*Plus command, A.1
- SET CONSTRAINT statement, 1.1
- SET function, 2.1
- SET ROLE statement, 1.1
- SET TRANSACTION statement, 1.1
- SHOW
-
- SQL*Plus command, A.1
- SHUTDOWN
-
- SQL*Plus command, A.1
- SIGN function, 2.1
- simple comparison condition, 4.1
- simple expressions, 3.1
- SIN function, 2.1
- SINH function, 2.1
- SOUNDEX function, 2.1
- spatial_datatypes, 6.1.2
- SPOOL
-
- SQL*Plus command, A.1
- SQL conditions, 4
-
- compound conditions, 4.1
- EQUALS_PATH condition, 4.1
- floating-point condition, 4.1
- group comparison condition, 4.1
- IN conditions, 4.1, 4.1
- IS A SET conditions, 4.1
- IS ANY condition, 4.1
- IS EMPTY conditions, 4.1
- IS OF TYPE conditions, 4.1
- IS PRESENT condition, 4.1
- LIKE condition, 4.1
- logical conditions, 4.1
- MEMBER condition, 4.1
- NULL conditions, 4.1
- range conditions, 4.1
- REGEXP_LIKE condition, 4.1
- simple comparison condition, 4.1
- SUBMULTISET conditions, 4.1
- UNDER_PATH condition, 4.1
- SQL Ecpressions
-
- scalar subquery expression, 3.1
- SQL Expression
-
- Function expression, 3.1
- SQL expressions, 3
-
- CASE expressions, 3.1
- compound expressions, 3.1
- CURSOR expression, 3.1
- DATETIME expressions, 3.1
- INTERVAL expressions, 3.1
- model expressions, 3.1
- object access expressions, 3.1
- simple expressions, 3.1
- type constructor expression, 3.1
- variable expression, 3.1
- SQL functions, 2
-
- ABS, 2.1
- ACOS, 2.1
- ADD_MONTHS, 2.1
- analytic, 2.1
- APPENDCHILDXML, 2.1
- ASCII, 2.1
- ASCIISTR, 2.1
- ASIN, 2.1
- ATAN, 2.1
- ATAN2, 2.1
- AVG, 2.1
- BFILENAME, 2.1
- BIN_TO_NUM, 2.1
- BITAND, 2.1
- CARDINALITY, 2.1
- CAST, 2.1
- CEIL, 2.1
- CHARTOROWID, 2.1
- CHR, 2.1
- CLUSTER_ID, 2.1
- CLUSTER_PROBABILITY, 2.1
- CLUSTER_SET, 2.1
- COALESCE, 2.1
- COLLECT, 2.1
- COMPOSE, 2.1
- CONCAT, 2.1
- CONVERT, 2.1
- CORR, 2.1
- CORR_K, 2.1
- CORR_S, 2.1
- COS, 2.1
- COSH, 2.1
- COUNT, 2.1
- COVAR_POP, 2.1
- COVAR_SAMP, 2.1
- CUME_DIST (aggregate), 2.1
- CUME_DIST (analytic), 2.1
- CURRENT_DATE, 2.1
- CURRENT_TIMESTAMP, 2.1
- CV, 2.1
- DBTIMEZONE, 2.1
- DECODE, 2.1
- DECOMPOSE, 2.1
- DENSE_RANK (aggregate), 2.1, 2.1
- DEPTH, 2.1
- DEREF, 2.1
- DUMP, 2.1
- EMPTY_BLOB, 2.1, 2.1
- EXISTSNODE, 2.1
- EXP, 2.1
- EXTRACT (datetime), 2.1
- EXTRACT (XML), 2.1
- EXTRACTVALUE, 2.1
- FIRST, 2.1
- FIRST_VALUE, 2.1, 2.1, 2.1, 2.1
- FLOOR, 2.1
- FROM_TZ, 2.1
- GREATEST, 2.1
- GROUP_ID, 2.1
- GROUPING, 2.1
- GROUPING_ID, 2.1
- HEXTORAW, 2.1
- INITCAP, 2.1
- INSTR, 2.1
- ITERATION_NUMBER, 2.1
- LAG, 2.1
- LAST, 2.1
- LAST_DAY, 2.1
- LAST_VALUE, 2.1
- LEAD, 2.1
- LEAST, 2.1
- LENGTH, 2.1
- LN, 2.1
- LNNVL, 2.1
- LOCALTIMESTAMP, 2.1
- LOG, 2.1
- LOWER, 2.1
- LPAD, 2.1
- LTRIM, 2.1
- MAKE_REF, 2.1
- MAX, 2.1
- MEDIAN, 2.1
- MIN, 2.1
- MOD, 2.1
- MONTHS_BETWEEN, 2.1
- NANVL, 2.1
- NCGR, 2.1
- NEW_TIME, 2.1
- NEXT_DAY, 2.1
- NLS_CHARSET_DECL_LEN, 2.1
- NLS_CHARSET_ID, 2.1
- NLS_CHARSET_NAME, 2.1
- NLS_INITCAP, 2.1
- NLS_LOWER, 2.1
- NLS_UPPER, 2.1
- NLSSORT, 2.1
- NTILE, 2.1
- NULLIF, 2.1
- NUMTODSINTERVAL, 2.1
- NUMTOYMINTERVAL, 2.1
- NVL, 2.1
- NVL2, 2.1
- ORA_HASH, 2.1
- PATH, 2.1
- PERCENT_RANK (aggregate), 2.1
- PERCENT_RANK (analytic), 2.1
- PERCENTILE_CONT, 2.1
- PERCENTILE_DISC, 2.1
- POWER, 2.1
- POWERMULTISET, 2.1
- POWERMULTISET_BY_CARDINALITY, 2.1
- PRESENTNNV, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1
- PRESENTV, 2.1
- PREVIOUS, 2.1
- RANK (aggregate), 2.1
- RANK (analytic), 2.1
- RATIO_TO_REPORT, 2.1
- RAWTOHEX, 2.1
- RAWTONHEX, 2.1
- REF, 2.1
- REFTOHEX, 2.1
- REGEXP_INSTR, 2.1
- REGEXP_REPLACE, 2.1
- REGEXP_SUBSTR, 2.1
- REGR_AVGX, 2.1
- REGR_AVGY, 2.1
- REGR_COUNT, 2.1
- REGR_INTERCEPT, 2.1
- REGR_R2, 2.1
- REGR_SLOPE, 2.1
- REGR_SXX, 2.1
- REGR_SXY, 2.1
- REGR_SYY, 2.1
- REMAINDER, 2.1
- REPLACE, 2.1
- ROUND (date), 2.1
- ROUND (number), 2.1
- ROW_NUMBER, 2.1
- ROWIDTOCHAR, 2.1
- ROWTONCHAR, 2.1
- RPAD, 2.1
- RTRIM, 2.1
- SCN_TO_TIMESTAMP, 2.1
- SESSIONTIMEZONE, 2.1
- SET, 2.1
- SIGN, 2.1
- SIN, 2.1
- SINH, 2.1
- SOUNDEX, 2.1
- SQRT, 2.1
- STATS_BINOMIAL_TEST, 2.1
- STATS_CROSSTAB, 2.1
- STATS_F_TEST, 2.1
- STATS_KS_TEST, 2.1
- STATS_MODE, 2.1
- STATS_MW_TEST, 2.1
- STATS_ONE_WAY_ANOVA, 2.1
- STATS_T_TEST_INDEP, 2.1
- STATS_T_TEST_INDEPU, 2.1
- STATS_T_TEST_ONE, 2.1
- STATS_T_TEST_PAIRED, 2.1
- STATS_WSR_TEST, 2.1
- STDDEV, 2.1
- STDDEV_POP, 2.1
- STDDEV_SAMP, 2.1
- SUBSTR, 2.1
- SUM, 2.1
- SYS_CONNECT_BY_PATH, 2.1
- SYS_CONTEXT, 2.1
- SYS_DBURIGEN, 2.1
- SYS_EXTRACT_UTC, 2.1
- SYS_GUID, 2.1
- SYS_TYPEID, 2.1
- SYS_XMLAGG, 2.1
- SYS_XMLGEN, 2.1
- SYSDATE, 2.1
- SYSTIMESTAMP, 2.1
- TAN, 2.1
- TANH, 2.1
- TIMESTAMP_TO_SCN, 2.1
- TO_BINARY_DOUBLE, 2.1
- TO_BINARY_FLOAT, 2.1
- TO_CHAR (character), 2.1
- TO_CHAR (datetime), 2.1
- TO_CHAR (number), 2.1
- TO_CLOB, 2.1
- TO_DATE, 2.1
- TO_DSINTERVAL, 2.1
- TO_LOB, 2.1
- TO_MULTI_BYTE, 2.1
- TO_NCHAR (character), 2.1
- TO_NCHAR (datetime), 2.1
- TO_NCHAR (number), 2.1
- TO_NCLOB, 2.1
- TO_NUMBER, 2.1
- TO_SINGLE_BYTE, 2.1
- TO_TIMESTAMP, 2.1
- TO_TIMESTAMP_TZ, 2.1
- TO_YMINTERVAL, 2.1
- TRANSLATE, 2.1
- TRANSLATE...USING, 2.1
- TREAT, 2.1
- TRIM, 2.1
- TRUNC (date), 2.1
- TRUNC (number), 2.1
- TZ_OFFSET, 2.1
- UID, 2.1
- UNISTR, 2.1
- UPDATEXML, 2.1
- UPPER, 2.1
- USER, 2.1
- user-defined function, 2.1
- USERENV, 2.1
- VALUE, 2.1
- VAR_POP, 2.1
- VAR_SAMP, 2.1
- VARIANCE, 2.1
- VSIZE, 2.1
- WIDTH_BUCKET, 2.1
- XMLAGG, 2.1
- XMLCOLATTVAL, 2.1
- XMLCONCAT, 2.1
- XMLELEMENT, 2.1
- XMLFOREST, 2.1
- XMLSEQUENCE, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 5.1, 5.1, 5.1
- XMLTRANSFORM, 2.1
- SQL statements, 1
-
- ALTER CLUSTER statement, 1.1
- ALTER DATABASE statement, 1.1
- ALTER DIMENSION statement, 1.1
- ALTER DISKGROUP statement, 1.1
- ALTER FUNCTION statement, 1.1
- ALTER INDEX statement, 1.1
- ALTER INDEXTYPE statement, 1.1
- ALTER JAVA statement, 1.1
- ALTER MATERIALIZED VIEW LOG statement, 1.1
- ALTER MATERIALIZED VIEW statement, 1.1
- ALTER OPERATOR statement, 1.1
- ALTER OUTLINE statement, 1.1
- ALTER PACKAGE statement, 1.1
- ALTER PROCEDURE statement, 1.1
- ALTER PROFILE statement, 1.1
- ALTER RESOURCE COST statement, 1.1
- ALTER ROLE statement, 1.1
- ALTER ROLLBACK SEGMENT statement, 1.1
- ALTER SEQUENCE statement, 1.1, 1.1
- ALTER SESSION statement, 1.1
- ALTER SYSTEM statement, 1.1
- ALTER TABLE statement, 1.1
- ALTER TABLESPACE statement, 1.1
- ALTER TRIGGER statement, 1.1
- ALTER TYPE statement, 1.1
- ALTER USER statement, 1.1
- ALTER VIEW statement, 1.1
- ANALYZE statement, 1.1
- ASSOCIATE STATISTICS statement, 1.1
- AUDIT statement, 1.1
- CALL statement, 1.1
- COMMENT statement, 1.1
- COMMIT statement, 1.1
- CREATE CLUSTER statement, 1.1
- CREATE CONTEXT statement, 1.1
- CREATE CONTROLFILE statement, 1.1
- CREATE DATABASE LINK statement, 1.1
- CREATE DATABASE statement, 1.1
- CREATE DIMENSION statement, 1.1
- CREATE DIRECTORY statement, 1.1
- CREATE DISKGROUP statement, 1.1
- CREATE FUNCTION statement, 1.1
- CREATE INDEX statement, 1.1
- CREATE INDEXTYPE statement, 1.1
- CREATE JAVA statement, 1.1
- CREATE LIBRARY statement, 1.1
- CREATE MATERIALIZED VIEW LOG statement, 1.1
- CREATE MATERIALIZED VIEW statement, 1.1
- CREATE OPERATOR statement, 1.1
- CREATE OUTLINE statement, 1.1
- CREATE PACKAGE BODY statement, 1.1
- CREATE PACKAGE statement, 1.1
- CREATE PFILE statement, 1.1
- CREATE PROCEDURE statement, 1.1
- CREATE PROFILE statement, 1.1
- CREATE RESTORE POINT, 1.1
- CREATE ROLE statement, 1.1
- CREATE ROLLBACK SEGMENT statement, 1.1
- CREATE SCHEMA statement, 1.1, 1.1
- CREATE SEQUENCE statement, 1.1
- CREATE SPFILE statement, 1.1
- CREATE SYNONYM statement, 1.1
- CREATE TABLE statement, 1.1
- CREATE TABLESPACE statement, 1.1
- CREATE TRIGGER statement, 1.1
- CREATE TYPE BODY statement, 1.1
- CREATE TYPE statement, 1.1
- CREATE USER statement, 1.1
- CREATE VIEW statement, 1.1
- DELETE statement, 1.1
- DISASSOCIATE STATISTICS statement, 1.1
- DROP CLUSTER statement, 1.1
- DROP CONTEXT statement, 1.1
- DROP DATABASE LINK statement, 1.1
- DROP DATABASE statement, 1.1
- DROP DIMENSION statement, 1.1
- DROP DIRECTORY statement, 1.1
- DROP DISKGROUP statement, 1.1
- DROP FUNCTION statement, 1.1
- DROP INDEX statement, 1.1
- DROP INDEXTYPE statement, 1.1
- DROP JAVA statement, 1.1
- DROP LIBRARY statement, 1.1
- DROP MATERIALIZED VIEW LOG statement, 1.1
- DROP MATERIALIZED VIEW statement, 1.1
- DROP OPERATOR statement, 1.1
- DROP OUTLINE statement, 1.1
- DROP PACKAGE statement, 1.1
- DROP PROCEDURE statement, 1.1
- DROP PROFILE statement, 1.1
- DROP RESTORE POINT, 1.1
- DROP ROLE statement, 1.1
- DROP ROLLBACK SEGMENT statement, 1.1
- DROP SEQUENCE statement, 1.1
- DROP SYNONYM statement, 1.1
- DROP TABLE statement, 1.1
- DROP TABLESPACE statement, 1.1
- DROP TRIGGER statement, 1.1
- DROP TYPE BODY statement, 1.1
- DROP TYPE statement, 1.1
- DROP USER statement, 1.1
- DROP VIEW statement, 1.1
- EXPLAIN PLAN statement, 1.1
- FLASHBACK DATABASE statement, 1.1
- FLASHBACK TABLE statement, 1.1
- GRANT statement, 1.1
- INSERT statement, 1.1
- LOCK TABLE statement, 1.1
- MERGE statement, 1.1
- NOAUDIT statement, 1.1
- PURGE statement, 1.1
- RENAME statement, 1.1
- REVOKE statement, 1.1
- ROLLBACK statement, 1.1
- SAVEPOINT statement, 1.1
- SELECT statement, 1.1
- SET CONSTRAINT statement, 1.1
- SET ROLE statement, 1.1
- SET TRANSACTION statement, 1.1
- TRUNCATE statement, 1.1
- UPDATE statement, 1.1
- SQL*Plus commands, A, A.1
-
- /(slash), A.1
- @ (at sign), A.1
- APPEND, A.1
- CHANGE, A.1
- CONNECT, A.1
- DEL, A.1
- DESCRIBE, A.1
- DISCONNECT, A.1
- EDIT, A.1
- EXECUTE, A.1
- EXIT, A.1
- GET, A.1
- HELP, A.1
- HOST, A.1
- INPUT, A.1
- LIST, A.1
- QUIT, A.1
- RUN, A.1
- SAVE, A.1
- SET, A.1
- SHOW, A.1
- SHUTDOWN, A.1
- SPOOL, A.1
- SQLPLUS, A.1
- START, A.1
- STARTUP, A.1
- SQL/DS datatypes
-
- restrictions on, 6.1.3, 6.1.3
- SQLPLUS
-
- SQL*Plus command, A.1
- SQRT function, 2.1
- START
-
- SQL*Plus command, A.1
- STARTUP
-
- SQL*Plus command, A.1
- statements, 1
-
- see also SQL statements
- STATS_BINOMIAL_TEST function, 2.1
- STATS_CROSSTAB function, 2.1
- STATS_F_TEST function, 2.1
- STATS_KS_TEST function, 2.1
- STATS_MODE function, 2.1
- STATS_MW_TEST function, 2.1
- STATS_ONE_WAY_ANOVA function, 2.1
- STATS_T_TEST_INDEP function, 2.1
- STATS_T_TEST_INDEPU function, 2.1
- STATS_T_TEST_ONE function, 2.1
- STATS_T_TEST_PAIRED function, 2.1
- STATS_WSR_TEST function, 2.1
- STDDEV function, 2.1
- STDDEV_POP function, 2.1
- STDDEV_SAMP function, 2.1
- Subclauses
-
- activate_standby_db_clause, 5.1
- add_binding_clause, 5.1
- add_column_clause, 5.1
- add_disk_clause, 5.1
- SUBMULTISET conditions, 4.1
- SUBSTR function, 2.1
- SUM function, 2.1
- Syntax for Subclauses, 5.1
- SYS_CONNECT_BY_PATH function, 2.1
- SYS_CONTEXT function, 2.1
- SYS_DBURIGEN function, 2.1
- SYS_EXTRACT_UTC function, 2.1
- SYS_GUID function, 2.1
- SYS_TYPEID function, 2.1
- SYS_XMLAGG function, 2.1
- SYS_XMLGEN function, 2.1
- SYSDATE function, 2.1
- SYSTIMESTAMP function, 2.1
T
- TAN function, 2.1
- TANH function, 2.1
- TIME datatype
-
- DB2, 6.1.3, 6.1.3, 6.1.3, 6.1.3
- SQL/DS, 6.1.3, 6.1.3, 6.1.3, 6.1.3
- time format models
-
- short, 7.1.2.1
- time zone
-
- formatting, 7.1.2.1
- TIMESTAMP datatype
-
- DB2, 6.1.3, 6.1.3, 6.1.3, 6.1.3
- SQL/DS, 6.1.3, 6.1.3, 6.1.3, 6.1.3
- TIMESTAMP_TO_SCN function, 2.1
- TO_BINARY_DOUBLE function, 2.1
- TO_BINARY_FLOAT function, 2.1
- TO_CHAR (character) function, 2.1
- TO_CHAR (datetime) function, 2.1
- TO_CHAR (number) function, 2.1
- TO_CLOB function, 2.1
- TO_DATE function, 2.1
- TO_DSINTERVAL function, 2.1
- TO_LOB function, 2.1
- TO_MULTI_BYTE function, 2.1
- TO_NCHAR (character) function, 2.1
- TO_NCHAR (datetime) function, 2.1
- TO_NCHAR (number) function, 2.1
- TO_NCLOB function, 2.1
- TO_NUMBER function, 2.1
- TO_SINGLE_BYTE function, 2.1
- TO_TIMESTAMP function, 2.1
- TO_TIMESTAMP_TZ function, 2.1
- TO_YMINTERVAL function, 2.1
- TRANSLATE function, 2.1
- TRANSLATE...USING function, 2.1
- TREAT function, 2.1
- TRIM function, 2.1
- TRUNC (date) function, 2.1
- TRUNC (number) function, 2.1
- TRUNCATE statement, 1.1
- type constructor expression, 3.1
- TZ_OFFSET function, 2.1
U
- UID function, 2.1
- UNDER_PATH condition, 4.1
- UNISTR function, 2.1
- UPDATE statement, 1.1
- UPDATEXML function, 2.1
- UPPER function, 2.1
- USER function, 2.1
- User-defined datatypes, 6.1
- user-defined function, 2.1
- USERENV function, 2.1
V
- VALUE function, 2.1
- VAR_POP function, 2.1
- VAR_SAMP function, 2.1
- VARGRAPHIC datatype
-
- DB2, 6.1.3, 6.1.3, 6.1.3, 6.1.3
- SQL/DS, 6.1.3, 6.1.3, 6.1.3, 6.1.3
- variable expression, 3.1
- VARIANCE function, 2.1
- VSIZE function, 2.1
W
- WIDTH_BUCKET function, 2.1
X
- XMLAGG function, 2.1
- XMLCOLATTVAL function, 2.1
- XMLCONCAT function, 2.1
- XMLELEMENT function, 2.1
- XMLFOREST function, 2.1
- XMLSEQUENCE function, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 2.1, 5.1, 5.1, 5.1
- XMLTRANSFORM function, 2.1