A
- ABS function, ABS
- ACOS function, ACOS
- ADD_MONTHS function, ADD_MONTHS
- aggregate function, Aggregate Functions
- ALL, Aggregate Functions
- DISTINCT, Aggregate Functions
- nested, Aggregate Functions
- NULL argument, NULL in SQL Functions
- ALL operator, Group Conditions
- ALL_ROWS hint, Optimizer Modes
- ANALYTIC clause, Analytic Functions
- analytic function, Analytic Functions
- AGGR_CONCAT, AGGR_CONCAT
- ANALYTIC clause, Analytic Functions
- AVG, AVG
- CORR, CORR
- COUNT, COUNT
- COVAR_POP, COVAR_POP
- COVAR_SAMP, COVAR_SAMP
- DENSE_RANK, DENSE_RANK
- FIRST_VALUE, FIRST_VALUE
- LAG, LAG
- LAST_VALUE, LAST_VALUE
- LEAD, LEAD
- location, Analytic Functions
- MAX, MAX
- MEDIAN, MEDIAN
- MIN, MIN
- NTILE, NTILE
- ORDER BY clause, Analytic Functions
- OVER clause, Analytic Functions
- PARTITION BY clause, Analytic Functions
- PERCENT_RANK, PERCENT_RANK
- PERCENTILE_CONT, PERCENTILE_CONT
- PERCENTILE_DISC, PERCENTILE_DISC
- RANK, RANK
- RATIO_TO_REPORT, RATIO_TO_REPORT
- REGR_AVGX, REGR_AVGX
- REGR_AVGY, REGR_AVGY
- REGR_COUNT, REGR_COUNT
- REGR_INTERCEPT, REGR_INTERCEPT
- REGR_R2, REGR_R2
- REGR_SLOPE, REGR_SLOPE
- REGR_SXX, REGR_SXX
- REGR_SXY, REGR_SXY
- REGR_SYY, REGR_SYY
- ROW_NUMBER, ROW_NUMBER
- STDDEV, STDDEV
- STDDEV_POP, STDDEV_POP
- STDDEV_SAMP, STDDEV_SAMP
- SUM, SUM
- VAR_POP, VAR_POP
- VAR_SAMP, VAR_SAMP
- VARIANCE, VARIANCE
- window, Analytic Functions
- AND operator, Operators Used in Conditional Expressions
- ANY operator, Group Conditions
- APPEND, Others
- APPEND_VALUES, Others
- APPENDCHILDXML function, APPENDCHILDXML
- arithmetic operator, General Operators
- Array type, User-Defined
- ASC
- ORDER BY clause, SELECT
- ASCII function, ASCII
- ASCIISTR function, ASCIISTR
- ASIN function, ASIN
- ATAN function, ATAN
- ATAN2 function, ATAN2
- AVG function, AVG
C
- CALL, CALL
- CARD, Others
- CAST function, CAST
- CEIL function, CEIL
- CHAR, String
- CHARTOROWID function, CHARTOROWID
- CHR function, CHR
- CLOB type, Large Object
- COALESCE function, COALESCE
- column, Tables
- integrity constraints, Tables
- primary key column, Indexes
- COMMENT, Comments
- comments, Comments
- adding, Comments
- for schema objects, Comments
- hints, Hints
- comparison operator, Operators Used in Conditional Expressions
- Complete recovery, ALTER DATABASE
- COMPOSE function, COMPOSE
- compound condition, Compound Conditions
- compound expression, Compound Expressions
- CONCAT function, CONCAT
- concatenation operator, General Operators
- Condition
- Simple, Simple Conditions
- condition
- BETWEEN, BETWEEN Condition
- EXISTS, EXISTS Condition
- group, Group Conditions
- IN, IN Condition
- IS NULL, IS NULL Condition
- LIKE, LIKE Condition
- REGEXP_LIKE, REGEXP_LIKE Condition
- Conditional clause
- SELECT, SELECT
- conditional clause
- DELETE, DELETE
- UPDATE, UPDATE
- CONNECT BY clause, Hierarchical Queries, Hierarchical Query Operators
- CONNECT_BY_ISCYCLE pseudo column, CONNECT_BY_ISCYCLE, Conditional Expressions in a Hierarchical Query
- CONNECT_BY_ISLEAF pseudo column, CONNECT_BY_ISLEAF
- CONNECT_BY_ROOT operator, Hierarchical Query Operators
- Constraint, Constraints
- CONVERT function, CONVERT
- CORR function, CORR
- correlated subquery, Subqueries
- COS function, COS
- COSH function, COSH
- COUNT function, Aggregate Functions, COUNT
- asterisk (*), Aggregate Functions
- COVAR_POP function, COVAR_POP
- COVAR_SAMP function, COVAR_SAMP
- CROSS
- inner join clause, SELECT
- CUBE
- SELECT, SELECT
- CUME_DIST function, CUME_DIST
- CURRENT_DATE function, CURRENT_DATE
- CURRENT_TIME function, CURRENT_TIME
- CURRENT_TIMESTAMP function, CURRENT_TIMESTAMP
- CURRVAL pseudo column, Sequences
D
- data definition language, Data Definition Language
- data manipulation language, Data Manipulation Language, Data Manipulation Language
- Data Type
- BINARY_DOUBLE Type, Number
- BINARY_FLOAT Type, Number
- Data type
- Array, User-Defined
- data type, Data Types
- BLOB, Large Object
- CHAR, String
- CLOB, Large Object
- conversion, Expression Conversion
- DATE, Datetime
- INTERVAL DAY TO SECOND, Interval
- INTERVAL YEAR TO MONTH, Interval
- LONG, String
- LONG RAW, String
- NCHAR, String
- NUMBER, Number
- NVARCHAR2, String
- RAW, String
- ROWID, Embedded
- TIME, Datetime
- TIMESTAMP, Datetime
- TIMESTAMP WITH LOCAL TIME ZONE, Datetime
- TIMESTAMP WITH TIME ZONE, Datetime
- VARCHAR, String
- VARCHAR2, String
- XMLTYPE, Large Object
- DATE literal, Datetime
- ANSI representation, Datetime
- datetime
- format element suffix, Datetime Types
- format string, Datetime Types
- datetime type, Datetime
- DBTIMEZONE function, DBTIMEZONE
- DDL, Data Definition Language
- DECODE function, DECODE
- NULL argument, Comparison Condition for NULL
- DECOMPOSE function, DECOMPOSE
- DELETE, DELETE
- DELETEXML function, DELETEXML
- DENSE_RANK
- used as an aggregate function, DENSE_RANK
- used as an analytic function, DENSE_RANK
- DENSE_RANK function, DENSE_RANK
- DESC
- ORDER BY clause, SELECT
- Direct-Path method, Others
- DML, Data Manipulation Language, Data Manipulation Language
- DOP, Parallel Query
- dual table, Dual Table
- DUMP function, DUMP
E
- embedded type, Embedded
- EMPTY_BLOB function, EMPTY_BLOB
- EMPTY_CLOB function, EMPTY_CLOB
- error logging clause
- INSERT, INSERT
- EXISTS condition, EXISTS Condition
- EXISTSNODE function, EXISTSNODE
- EXP function, EXP
- expression
- compound, Compound Expressions
- list, List
- simple, Simple Expressions
- syntax diagram, Overview
- EXTRACT function, EXTRACT
- EXTRACT(XML) function, EXTRACT(XML)
- EXTRACTVALUE function, EXTRACTVALUE
F
- fast refresh
- general conditions, Fast Refresh
- materialized views containing aggregate
functions, Fast Refresh
- FIRST function, FIRST
- FIRST_ROWS hint, Optimizer Modes
- FIRST_VALUE function, FIRST_VALUE
- FLOOR function, FLOOR
- FOR UPDATE clause
- SELECT, SELECT
- format modifier, Format Modifiers
- FM, Format Modifiers
- FX, Format Modifiers
- format string, Format Strings
- datetime, Datetime Types
- datetime format element suffix, Datetime Types
- FM, Format Modifiers
- format modifier, Format Modifiers
- FX, Format Modifiers
- NUMBER, NUMBER Types
- FROM clause
- SELECT, SELECT
- FROM_TZ function, FROM_TZ
- FULL hint, Access Modes
- function
- aggregate, Aggregate Functions
- analytic, Analytic Functions
- saving a return value, Overview
- single row, Single Row Functions
- function expression, Functions
G
- GETBLOBVAL function, GETBLOBVAL
- GETCLOBVAL function, GETCLOBVAL
- GETROOTELEMENT function, GETROOTELEMENT
- GETSTRINGVAL function, GETSTRINGVAL
- GREATEST function, GREATEST
- GROUP BY clause, Aggregate Functions
- SELECT, SELECT
- group condition, Group Conditions
- ALL, Group Conditions
- ANY, Group Conditions
- SOME, Group Conditions
- GROUP_ID function, GROUP_ID
- GROUPING function, GROUPING
- GROUPING_ID function, GROUPING_ID
H
- HAVING clause, Aggregate Functions, SELECT
- HEXTORAW function, HEXTORAW
- hierarchical query, LEVEL, Hierarchical Queries
- cyclic hierarchy, Conditional Expressions in a Hierarchical Query
- example, How to Execute a Hierarchical Query
- level, How to Execute a Hierarchical Query
- the order of result display, How to Execute a Hierarchical Query
- Hierarchical query clause
- SELECT, SELECT
- hint
- APPEND_VALUES, Others
- INDEX_SS, Access Modes
- MERGE_AJ, Join Modes
- MERGE_SJ, Join Modes
- NL_AJ, Join Modes
- NL_SJ, Join Modes
- NO_INDEX_RS, Access Modes
- NO_INDEX_SS, Access Modes
- hints, Hints
- access mode, Access Modes
- ALL_ROWS, Optimizer Modes
- APPEND, Others
- CARD, Others
- FIRST_ROWS, Optimizer Modes
- FULL, Access Modes
- IGNORE_ROW_ON_DUPKEY_INDEX, Others
- INDEX, Access Modes
- INDEX_ASC, Access Modes
- INDEX_DESC, Access Modes
- INDEX_FFS, Access Modes
- INDEX_RS, Access Modes
- join mode, Join Modes
- join order, Join Orders
- LEADING, Join Orders
- MONITOR, Others
- NO_EXPAND, Others
- NO_INDEX, Access Modes
- NO_INDEX_FFS, Access Modes
- NO_JOIN_ELIMINATION, Query Transformations
- NO_MERGE, Query Transformations
- NO_MONITOR, Others
- NO_PARALLEL, Parallel Processing
- NO_QUERY_TRANSFORMATION, Query Transformations
- NO_REWRITE, Materialized Views
- NO_UNNEST, Query Transformations
- NO_USE_HASH, Join Modes
- NO_USE_MERGE, Join Modes
- NO_USE_NL, Join Modes
- NOAPPEND, Others
- optimizer mode, Optimizer Modes
- ORDERED, Join Orders
- PARALLEL, Parallel Processing
- PQ_DISTRIBUTE, Parallel Processing
- query transformation, Query Transformations
- REWRITE, Materialized Views
- syntax, Hints
- types, Hints
- UNNEST, Query Transformations
- USE_CONCAT, Others
- USE_HASH, Join Modes
- USE_MERGE, Join Modes
- USE_NL, Join Modes
- USE_NL_WITH_INDEX, Join Modes
I
- I, INET_ATON
- IGNORE_ROW_ON_DUPKEY_INDEX, Others
- IN condition, IN Condition
- Incomplete recovery, ALTER DATABASE
- index, Indexes
- application, Indexes
- deletion, Indexes
- for multiple columns, Indexes
- management, Indexes
- INDEX hint, Access Modes
- INDEX_ASC hint, Access Modes
- INDEX_DESC hint, Access Modes
- INDEX_FFS hint, Access Modes
- INDEX_RS hint, Access Modes
- INDEX_SS hint, Access Modes
- INET_ATON function, INET_ATON
- INET_NTOA function, INET_NTOA
- INITCAP function, INITCAP
- inline view, Subqueries
- INNER
- inner join clause, SELECT
- inner join clause
- SELECT, SELECT
- INSERT, INSERT
- INSERTCHILDXML function, INSERTCHILDXML
- INSERTCHILDXMLAFTER function, INSERTCHILDXMLAFTER
- INSERTCHILDXMLBEFORE function, INSERTCHILDXMLBEFORE
- INSERTXMLAFTER function, INSERTXMLAFTER
- INSERTXMLBEFORE function, INSERTXMLBEFORE
- INSTR function, INSTR
- INSTRB function, INSTR
- integrity constraints, Tables
- referential integrity, Tables
- INTERSECTION operator, General Operators
- interval literal, Interval
- DAY TO SECOND, Interval
- YEAR TO MONTH, Interval
- interval type, Interval
- INTO clause
- CALL, CALL
- INSERT, INSERT
- MERGE, MERGE
- IS NOT NULL, Comparison Condition for NULL
- IS NULL, Comparison Condition for NULL
- IS NULL condition, IS NULL Condition
- ISFRAGMENT function, ISFRAGMENT
J
- Join, Joins
- anti-join, Anti-joins
- Cartesian product, Join Conditions
- Cartesian Products, Join Conditions
- Equi join, Equi Joins
- Inner join, Inner Joins
- Join condition, Join Conditions
- Self join, Self Joins
- semi-join, Semi-joins
- Join clause
- SELECT, SELECT
L
- LAG function, LAG
- large object type, Large Object
- LAST function, LAST
- LAST_DAY function, LAST_DAY
- LAST_VALUE function, LAST_VALUE
- LEAD function, LEAD
- LEADING hint, Join Orders
- LEAST function, LEAST
- LEFT
- outer join clause, SELECT
- LENGTH function, LENGTH
- LENGTHB function, LENGTH
- LEVEL pseudo column, LEVEL
- LEVEL pseudo-column, How to Execute a Hierarchical Query
- LIKE condition, LIKE Condition
- LISTAGG function, LISTAGG
- LISTAGG_CONCAT function, AGGR_CONCAT
- Literal
- DATE, Datetime
- literal, Literals
- interval, Interval
- numeric, Numeric
- string, String
- TIME, Datetime
- TIMESTAMP, Datetime
- TIMESTAMP WITH LOCAL TIME ZONE, Datetime
- TIMESTAMP WITH TIME ZONE, Datetime
- LN function, LN
- LNNVL function, LNNVL
- LOCALTIMESTAMP function, LOCALTIMESTAMP
- LOG function, LOG
- logical operator, Operators Used in Conditional Expressions
- AND, Operators Used in Conditional Expressions
- and OR, Operators Used in Conditional Expressions
- NOT, Operators Used in Conditional Expressions
- LONG RAW type, String
- LONG type, String
- LOWER function, LOWER
- LPAD function, LPAD
- LTRIM function, LTRIM
M
- MAX function, MAX
- MEDIAN function, MEDIAN
- MERGE, MERGE
- MERGE_AJ hint, Join Modes
- MERGE_INSERT clause
- MERGE, MERGE
- MERGE_SJ hint, Join Modes
- MERGE_UPDATE clause
- MERGE, MERGE
- method for computing a cumulative distribution, CUME_DIST
- MIN function, MIN
- MINUS operator, General Operators
- MOD function, MOD
- MONITOR, Others
- MONTHS_BETWEEN function, MONTHS_BETWEEN
- MULTI TABLE INSERT
- INSERT, INSERT
N
- namespace
- about schema object, Schema Object Names
- NANVL function, NANVL
- NATURAL
- inner join clause, SELECT
- outer join clause, SELECT
- NCHAR type, String
- nested aggregate function, Aggregate Functions
- nested subquery, Subqueries
- NEW_TIME function, NEW_TIME
- NEXT_DAY function, NEXT_DAY
- NEXTVAL pseudo column, Sequences
- NL_AJ hint, Join Modes
- NL_SJ hint, Join Modes
- NLS_CHARSET_ID function, NLS_CHARSET_ID
- NLS_DATE_FORMAT initialization parameter, Datetime
- NLS_INITCAP function, NLS_INITCAP
- NLS_LOWER function, NLS_LOWER
- NLS_TIME_FORMAT initialization parameter, Datetime
- NLS_TIMESTAMP_FORMAT initialization
parameter, Datetime
- NLS_TIMESTAMP_TZ_FORMAT initialization
parameter, Datetime
- NLS_UPPER function, NLS_UPPER
- NLSSORT function, NLSSORT
- NO_EXPAND, Others
- NO_INDEX hint, Access Modes
- NO_INDEX_FFS hint, Access Modes
- NO_INDEX_RS hint, Access Modes
- NO_INDEX_SS hint, Access Modes
- NO_JOIN_ELIMINATION hint, Query Transformations
- NO_MERGE hint, Query Transformations
- NO_MONITOR, Others
- NO_PARALLEL hint, Parallel Processing
- NO_QUERY_TRANSFORMATION hint, Query Transformations
- NO_REWRITE, Materialized Views
- NO_UNNEST hint, Query Transformations
- NO_USE_HASH hint, Join Modes
- NO_USE_MERGE hint, Join Modes
- NO_USE_NL hint, Join Modes
- NOAPPEND, Others
- NOT operator, Operators Used in Conditional Expressions
- NOWAIT
- FOR UPDATE clause, SELECT
- NTILE function, NTILE
- NULL, NULL
- in comparison condition, Comparison Condition for NULL
- in SQL function argument, NULL in SQL Functions
- used in aggregate functions, NULL in SQL Functions
- used in DECODE, Comparison Condition for NULL
- NULLIF function, NULLIF
- NULLS FIRST
- ORDER BY clause, SELECT
- NULLS LAST
- ORDER BY clause, SELECT
- NUMBER
- format string, NUMBER Types
- NUMBER type, Number
- precision, Number
- scale, Number
- number type, Number
- numeric literal, Numeric
- NUMTODSINTERVAL function, NUMTODSINTERVAL
- NUMTOYMINTERVAL function, NUMTOYMINTERVAL
- NVARCHAR2 type, String
- NVL function, NVL
- NULL argument, NULL in SQL Functions
- NVL2 function, NVL2
O
- object
- name
- identifier, Schema Object Names
- rule, Schema Object Names
- Object Privilege
- ALTER, GRANT
- DELETE, GRANT
- INDEX, GRANT
- INSERT, GRANT
- READ, GRANT
- REFERENCES, GRANT
- SELECT, GRANT
- TRUNCATE, GRANT
- UPDATE, GRANT
- WRITE, GRANT
- OF
- FOR UPDATE clause, SELECT
- ON
- inner join clause, SELECT
- outer join clause, SELECT
- operator
- arithmetic, General Operators
- binary, General Operators
- comparison, Operators Used in Conditional Expressions
- concatenation, General Operators
- logical, Operators Used in Conditional Expressions
- precedence, Operators Used in Conditional Expressions
- set, General Operators
- unary, General Operators
- OR operator, Operators Used in Conditional Expressions
- ORA_HASH function, ORA_HASH
- ORDER BY clause
- in an analytic function, Analytic Functions
- SELECT, SELECT
- ORDERED hint, Join Orders
- outer join, Outer Joins
- outer join clause
- SELECT, SELECT
- outer join operator, Outer Joins
- OVER clause, Analytic Functions
- OVERLAPS function, OVERLAPS
P
- PARALLEL hint, Parallel Processing
- parallel query, Parallel Query
- partial text match
- aggregate function compatibility, Rewrite Methods
- column compatibility, Rewrite Methods
- PARTITION
- SELECT, SELECT
- PARTITION BY clause
- in an analytic function, Analytic Functions
- PERCENT_RANK function, PERCENT_RANK
- PERCENTILE_CONT function, PERCENTILE_CONT
- PERCENTILE_DISC function, PERCENTILE_DISC
- position
- ORDER BY clause, SELECT
- POWER function, POWER
- PQ_DISTRIBUTE hint, Parallel Processing
- precision
- range, Number
- primary key column, Indexes
- usage of sequence, Sequences
- PRIOR operator, Hierarchical Query Operators
- pseudo column, Pseudo Columns
- CONNECT_BY_ISLEAF, CONNECT_BY_ISLEAF
- LEVEL, LEVEL
- ROWID, ROWID
- ROWNUM, ROWNUM
- pseudo column럼
- CONNECT_BY_ISCYCLE, CONNECT_BY_ISCYCLE
R
- RANK function, RANK
- RATIO_TO_REPORT function, RATIO_TO_REPORT
- RAW type, String
- RAWTOHEX function, RAWTOHEX
- RECYCLEBIN function, FLASHBACK TABLE
- refresh, Refresh
- complete refresh, Complete Refresh
- fast refresh, Fast Refresh
- REGEXP_COUNT function, REGEXP_COUNT
- REGEXP_INSTR function, REGEXP_INSTR
- REGEXP_LIKE condition, REGEXP_LIKE Condition
- REGEXP_REPLACE function, REGEXP_REPLACE
- REGEXP_SUBSTR function, REGEXP_SUBSTR
- REGR_AVGX function, REGR_AVGX
- REGR_AVGY function, REGR_AVGY
- REGR_COUNT function, REGR_COUNT
- REGR_INTERCEPT function, REGR_INTERCEPT
- REGR_R2 function, REGR_R2
- REGR_SLOPE function, REGR_SLOPE
- REGR_SXX function, REGR_SXX
- REGR_SXY function, REGR_SXY
- REGR_SYY function, REGR_SYY
- REMAINDER function, REMAINDER
- REPLACE function, REPLACE
- reserved word, Reserved Words
- RETURNING clause
- DELETE, DELETE
- INSERT, INSERT
- UPDATE, UPDATE
- REVERSE function, REVERSE
- REWRITE, Materialized Views
- rewrite method
- full text match, Rewrite Methods
- partial text match, Rewrite Methods
- RIGHT
- outer join clause, SELECT
- ROLLUP
- SELECT, SELECT
- ROUND function (date), ROUND(date)
- ROUND function (number), ROUND(number)
- row, Tables
- ROW_NUMBER function, ROW_NUMBER
- ROWID
- structure, ROWID
- ROWID pseudo column, ROWID
- ROWID type, Embedded
- ROWIDTOCHAR function, ROWIDTOCHAR
- ROWNUM pseudo column, ROWNUM
- RPAD function, RPAD
- RTRIM function, RTRIM
S
- scalar subquery, Subqueries
- scale
- range, Number
- schema, Schema Objects
- schema object, Schema Objects
- name, Schema Object Names
- namespace, Schema Object Names
- syntax, Syntax for Schema Objects
- schema object privilege
- ALTER, GRANT
- DELETE, GRANT
- INDEX, GRANT
- INSERT, GRANT
- READ, GRANT
- REFERENCES, GRANT
- SELECT, GRANT
- TRUNCATE, GRANT
- UPDATE, GRANT
- WRITE, GRANT
- Scientific Notation, Numeric
- SELECT, SQL Queries, SELECT
- HAVING clause, SELECT
- select_list clause
- SELECT, SELECT
- sequence, Sequences
- creation, Sequences
- increased point, Sequences
- increment and decrement, Sequences
- initial value, Sequences
- initialization, Sequences
- location of pseudo column, Sequences
- session management language, Transaction and Session Management Language
- SESSIONTIMEZONE function, SESSIONTIMEZONE
- SET clause
- UPDATE, UPDATE
- set operator, General Operators
- INTERSECTION, General Operators
- MINUS, General Operators
- SELECT, SELECT
- UNION, General Operators
- UNION ALL, General Operators
- SIBLINGS
- ORDER BY clause, SELECT
- SIGN function, SIGN
- Simple Condition, Simple Conditions
- simple condition, Simple Conditions
- simple expression, Simple Expressions
- SIN function, SIN
- single row function, Single Row Functions
- SINGLE TABLE INSERT
- INSERT, INSERT
- SINH function, SINH
- SKEW function, SKEW
- SKIP LOCKED
- FOR UPDATE clause, SELECT
- SOME operator, Group Conditions
- SQL, Overview
- SQL function
- ABS, ABS
- ACOS, ACOS
- ADD_MONTHS, ADD_MONTHS
- AGGR_CONCAT, AGGR_CONCAT
- APPENDCHILDXML, APPENDCHILDXML
- ASCII, ASCII
- ASCIISTR, ASCIISTR
- ASIN, ASIN
- ATAN, ATAN
- ATAN2, ATAN2
- AVG, AVG
- BITAND, BITAND
- CAST, CAST
- CEIL, CEIL
- CHARTOROWID, CHARTOROWID
- CHR, CHR
- COALESCE, COALESCE
- COMPOSE, COMPOSE
- CONCAT, CONCAT
- CONVERT, CONVERT
- CORR, CORR
- COS, COS
- COSH, COSH
- COUNT, Aggregate Functions, COUNT
- COVAR_POP, COVAR_POP
- COVAR_SAMP, COVAR_SAMP
- CUME_DIST, CUME_DIST
- CURRENT_DATE, CURRENT_DATE
- CURRENT_TIME, CURRENT_TIME
- CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
- DBTIMEZONE, DBTIMEZONE
- DECODE, DECODE
- DECOMPOSE, DECOMPOSE
- DELETEXML, DELETEXML
- DENSE_RANK, DENSE_RANK
- DUMP, DUMP
- EMPTY_BLOB, EMPTY_BLOB
- EMPTY_CLOB, EMPTY_CLOB
- EXISTSNODE, EXISTSNODE
- EXP, EXP
- EXTRACT, EXTRACT
- EXTRACT(XML), EXTRACT(XML)
- EXTRACTVALUE, EXTRACTVALUE
- FIRST, FIRST
- FLOOR, FLOOR
- FROM_TZ, FROM_TZ
- GETBLOBVAL, GETBLOBVAL
- GETCLOBVAL, GETCLOBVAL
- GETROOTELEMENT, GETROOTELEMENT
- GETSTRINGVAL, GETSTRINGVAL
- GREATEST, GREATEST
- GROUP_ID, GROUP_ID
- GROUPING, GROUPING
- GROUPING_ID, GROUPING_ID
- HEXTORAW, HEXTORAW
- INET_ATON, INET_ATON
- INET_NTOA, INET_NTOA
- INITCAP, INITCAP
- INSERTCHILDXML, INSERTCHILDXML
- INSERTCHILDXMLAFTER, INSERTCHILDXMLAFTER
- INSERTCHILDXMLBEFORE, INSERTCHILDXMLBEFORE
- INSERTXMLAFTER, INSERTXMLAFTER
- INSERTXMLBEFORE, INSERTXMLBEFORE
- INSTR, INSTR
- INSTRB, INSTR
- ISFRAGMENT, ISFRAGMENT
- KURT, KURT
- LAG, LAG
- LAST, LAST
- LAST_DAY, LAST_DAY
- LEAD, LEAD
- LEAST, LEAST
- LENGTH, LENGTH
- LENGTHB, LENGTH
- LISTAGG, LISTAGG
- LN, LN
- LNNVL, LNNVL
- LOCALTIMESTAMP, LOCALTIMESTAMP
- LOG, LOG
- LOWER, LOWER
- LPAD, LPAD
- LTRIM, LTRIM
- MAX, MAX
- MEDIAN, MEDIAN
- MIN, MIN
- MOD, MOD
- MONTH_BETWEEN, MONTHS_BETWEEN
- NANVL, NANVL
- NEW_TIME, NEW_TIME
- NEXT_DAY, NEXT_DAY
- NLS_CHARSET_ID, NLS_CHARSET_ID
- NLS_INITCAP, NLS_INITCAP
- NLS_LOWER, NLS_LOWER
- NLS_UPPER, NLS_UPPER
- NLSSORT, NLSSORT
- NULLIF, NULLIF
- NUMTODSINTERVAL, NUMTODSINTERVAL
- NUMTOYMINTERVAL, NUMTOYMINTERVAL
- NVL, NVL
- NVL2, NVL2
- ORA_HASH, ORA_HASH
- OVERLAPS, OVERLAPS
- PERCENT_RANK, PERCENT_RANK
- PERCENTILE_CONT, PERCENTILE_CONT
- PERCENTILE_DISC, PERCENTILE_DISC
- POWER, POWER
- RANK, RANK
- RATIO_TO_REPORT, RATIO_TO_REPORT
- RAWTOHEX, RAWTOHEX
- REGEXP_COUNT, REGEXP_COUNT
- REGEXP_INSTR, REGEXP_INSTR
- REGEXP_REPLACE, REGEXP_REPLACE
- REGEXP_SUBSTR, REGEXP_SUBSTR
- REGR_AVGX, REGR_AVGX
- REGR_AVGY, REGR_AVGY
- REGR_COUNT, REGR_COUNT
- REGR_INTERCEPT, REGR_INTERCEPT
- REGR_R2, REGR_R2
- REGR_SLOPE, REGR_SLOPE
- REGR_SXX, REGR_SXX
- REGR_SXY, REGR_SXY
- REGR_SYY, REGR_SYY
- REMAINDER, REMAINDER
- REPLACE, REPLACE
- REVERSE, REVERSE
- ROUND(date), ROUND(date)
- ROUND(number), ROUND(number)
- ROW_NUMBER, ROW_NUMBER
- ROWIDTOCHAR, ROWIDTOCHAR
- RPAD, RPAD
- RTRIM, RTRIM
- SESSIONTIMEZONE, SESSIONTIMEZONE
- SIGN, SIGN
- SIN, SIN
- SINH, SINH
- SKEW, SKEW
- SQRT, SQRT
- STDDEV, STDDEV
- STDDEV_POP, STDDEV_POP
- STDDEV_SAMP, STDDEV_SAMP
- SUBSTR, SUBSTR
- SUBSTRB, SUBSTR
- SUM, SUM
- SYS_CONNECT_BY_PATH, SYS_CONNECT_BY_PATH
- SYS_CONTEXT, SYS_CONTEXT
- SYS_EXTRACT_UTC, SYS_EXTRACT_UTC
- SYS_GUID, SYS_GUID
- SYSDATE, SYSDATE
- SYSTIME, SYSTIME
- SYSTIMESTAMP, SYSTIMESTAMP
- TAN, TAN
- TANH, TANH
- TIMESTAMP_TO_TSN, TIMESTAMP_TO_TSN
- TO_BINARY_DOUBLE, TO_BINARY_DOUBLE
- TO_BINARY_FLOAT, TO_BINARY_FLOAT
- TO_CHAR(character), TO_CHAR(character)
- TO_CHAR(datetime), TO_CHAR(datetime)
- TO_CHAR(number), TO_CHAR(number)
- TO_CLOB, TO_CLOB
- TO_DATE, Datetime, TO_DATE
- TO_DSINTERVAL, TO_DSINTERVAL
- TO_LOB, TO_LOB
- TO_MULTI_BYTE, TO_MULTI_BYTE
- TO_NCHAR, TO_NCHAR
- TO_NUMBER, TO_NUMBER
- TO_SINGLE_BYTE, TO_SINGLE_BYTE
- TO_TIME, Datetime, TO_TIME
- TO_TIMESTAMP, Datetime, TO_TIMESTAMP
- TO_TIMESTAMP_TZ, Datetime, TO_TIMESTAMP_TZ
- TO_YMINTERVAL, TO_YMINTERVAL
- TRANSLATE, TRANSLATE
- TRIM, TRIM
- TRUNC, Datetime
- TRUNC(date), TRUNC(date)
- TRUNC(number), TRUNC(number)
- TSN_TO_TIMESTAMP, TSN_TO_TIMESTAMP
- TZ_OFFSET, TZ_OFFSET
- TZ_SHIFT, TZ_SHIFT
- UID, UID
- UNISTR, UNISTR
- UPDATEXML, UPDATEXML
- UPPER, UPPER
- USER, USER
- USERENV, USERENV
- VAR_POP, VAR_POP
- VAR_SAMP, VAR_SAMP
- VARIANCE, VARIANCE
- VSIZE, VSIZE
- XMLAGG, XMLAGG
- XMLCAST, XMLCAST
- XMLCDATA, XMLCDATA
- XMLCOLATTVAL, XMLCOLATTVAL
- XMLCOMMENT, XMLCOMMENT
- XMLCONCAT, XMLCONCAT
- XMLELEMENT, XMLELEMENT
- XMLEXISTS, XMLEXISTS
- XMLFOREST, XMLFOREST
- XMLPARSE, XMLPARSE
- XMLPI, XMLPI
- XMLQUERY, XMLQUERY
- XMLROOT, XMLROOT
- XMLSERIALIZE, XMLSERIALIZE
- XMLTABLE, XMLTABLE
- XMLTRANSFORM, XMLTRANSFORM
- SQL query, SELECT
- SQL standard, SQL Standard
- level, SQL Standard
- SQL-92, SQL Standard
- SQL-99, SQL Standard
- SQL 질의어, SQL Queries
- SQRT function, SQRT
- START WITH clause, Hierarchical Queries, Conditional Expressions in a Hierarchical Query
- STDDEV function, STDDEV
- STDDEV_POP function, STDDEV_POP
- STDDEV_SAMP function, STDDEV_SAMP
- string literal, String
- string type, String
- Subquery, Subqueries
- Inline view, Subqueries
- Nested, Subqueries
- subquery, INSERT
- correlated, Subqueries
- INSERT, INSERT
- scalar, Subqueries
- subquery expression, Subquery Expressions
- location, Subquery Expressions
- SUBSTR function, SUBSTR
- SUBSTRB function, SUBSTR
- SUM function, SUM
- synonym, Synonyms
- share, Synonyms
- SYS_CONNECT_BY_PATH function, SYS_CONNECT_BY_PATH
- SYS_CONTEXT function, SYS_CONTEXT
- SYS_EXTRACT_UTC function, SYS_EXTRACT_UTC
- SYS_GUID function, SYS_GUID
- SYSDATE function, SYSDATE
- System Privilege
- ALTER ANY INDEX, GRANT
- ALTER ANY PROCEDURE, GRANT
- ALTER ANY ROLE, GRANT
- ALTER ANY SEQUENCE, GRANT
- ALTER ANY TABLE, GRANT
- ALTER DATABASE, GRANT
- ALTER MATERIALIZED VIEW, GRANT
- ALTER SESSION, GRANT
- ALTER SYSTEM, GRANT
- ALTER TABLESPACE, GRANT
- ALTER USER, GRANT
- AUDIT ANY, GRANT
- AUDIT SYSTEM, GRANT
- COMMENT ANY TABLE, GRANT
- CREATE ANY DIRECTORY, GRANT
- CREATE ANY INDEX, GRANT
- CREATE ANY LIBRARY, GRANT
- CREATE ANY MATERIALIZED VIEW, GRANT
- CREATE ANY PROCEDURE, GRANT
- CREATE ANY SEQUENCE, GRANT
- CREATE ANY SYNONYM, GRANT
- CREATE ANY TABLE, GRANT
- CREATE ANY VIEW, GRANT
- CREATE DATABASE LINK, GRANT
- CREATE LIBRARY, GRANT
- CREATE MATERIALIZED VIEW, GRANT
- CREATE PROCEDURE, GRANT
- CREATE PUBLIC DATABASE LINK, GRANT
- CREATE PUBLIC SYNONYM, GRANT
- CREATE ROLE, GRANT
- CREATE SEQUENCE, GRANT
- CREATE SESSION, GRANT
- CREATE SYNONYM, GRANT
- CREATE TABLE, GRANT
- CREATE TABLESPACE, GRANT
- CREATE USER, GRANT
- CREATE VIEW, GRANT
- DELETE ANY TABLE, GRANT
- DROP ANY DIRECTORY, GRANT
- DROP ANY INDEX, GRANT
- DROP ANY LIBRARY, GRANT
- DROP ANY PROCEDURE, GRANT
- DROP ANY ROLE, GRANT
- DROP ANY SEQUENCE, GRANT
- DROP ANY SYNONYM, GRANT
- DROP ANY TABLE, GRANT
- DROP ANY VIEW, GRANT
- DROP MATERIALIZED VIEW, GRANT
- DROP PUBLIC DATABASE LINK, GRANT
- DROP PUBLIC SYNONYM, GRANT
- DROP TABLESPACE, GRANT
- DROP USER, GRANT
- EXECUTE ANY LIBRARY, GRANT
- EXECUTE ANY PROCEDURE, GRANT
- GRANT ANY OBJECT PRIVILEGE, GRANT
- GRANT ANY PRIVILEGE, GRANT
- GRANT ANY ROLE, GRANT
- INSERT ANY TABLE, GRANT
- SELECT ANY SEQUENCE, GRANT
- SELECT ANY TABLE, GRANT
- SYSDBA, GRANT
- TRUNCATE ANY TABLE, GRANT
- UPDATE ANY TABLE, GRANT
- system privilege
- ALTER ANY INDEX, GRANT
- ALTER ANY PROCEDURE, GRANT
- ALTER ANY ROLE, GRANT
- ALTER ANY SEQUENCE, GRANT
- ALTER ANY TABLE, GRANT
- ALTER DATABASE, GRANT
- ALTER MATERIALIZED VIEW, GRANT
- ALTER SYSTEM, GRANT
- ALTER TABLESPACE, GRANT
- ALTER USER, GRANT
- AUDIT ANY, GRANT
- AUDIT SYSTEM, GRANT
- COMMENT ANY TABLE, GRANT
- CREATE ANY DIRECTORY, GRANT
- CREATE ANY INDEX, GRANT
- CREATE ANY LIBRARY, GRANT
- CREATE ANY MATERIALIZED VIEW, GRANT
- CREATE ANY PROCEDURE, GRANT
- CREATE ANY SEQUENCE, GRANT
- CREATE ANY SYNONYM, GRANT
- CREATE ANY TABLE, GRANT
- CREATE ANY VIEW, GRANT
- CREATE DATABASE LINK, GRANT
- CREATE LIBRARY, GRANT
- CREATE MATERIALIZED VIEW, GRANT
- CREATE PROCEDURE, GRANT
- CREATE PUBLIC SYNONYM, GRANT
- CREATE ROLE, GRANT
- CREATE SEQUENCE, GRANT
- CREATE SESSION, GRANT
- CREATE SYNONYM, GRANT
- CREATE TABLE, GRANT
- CREATE TABLESPACE, GRANT
- CREATE USER, GRANT
- CREATE VIEW, GRANT
- DELETE ANY TABLE, GRANT
- DROP ANY DIRECTORY, GRANT
- DROP ANY INDEX, GRANT
- DROP ANY LIBRARY, GRANT
- DROP ANY PROCEDURE, GRANT
- DROP ANY ROLE, GRANT
- DROP ANY SEQUENCE, GRANT
- DROP ANY SYNONYM, GRANT
- DROP ANY TABLE, GRANT
- DROP ANY VIEW, GRANT
- DROP MATERIALIZED VIEW, GRANT
- DROP PUBLIC DATABASE LINK, GRANT
- DROP PUBLIC SYNONYM, GRANT
- DROP TABLESPACE, GRANT
- DROP USER, GRANT
- EXECUTE ANY LIBRARY, GRANT
- EXECUTE ANY PROCEDURE, GRANT
- GRANT ANY OBJECT PRIVILEGE, GRANT
- GRANT ANY PRIVILEGE, GRANT
- GRANT ANY ROLE, GRANT
- INSERT ANY TABLE, GRANT
- SELECT ANY SEQUENCE, GRANT
- SELECT ANY TABLE, GRANT
- SYSDBA, GRANT
- UPDATE ANY TABLE, GRANT
- SYSTIME function, SYSTIME
- SYSTIMESTAMP function, SYSTIMESTAMP
T
- Table
- hint types, Hints
- table, Tables
- conversion of data type, Expression Conversion
- data types, Data Types
- datetime type format element - suffix, Datetime Types
- datetime type format string - format element, Datetime Types
- format strings for rounding off, ROUND(date)
- NUMBER type format string - elements, NUMBER Types
- NUMBER type value - examples of outputting a NUMBER type
format string, NUMBER Types
- operator precedence, Operators Used in Conditional Expressions
- schema object privilege types, GRANT
- set operator and operation result, General Operators
- system privilege type, GRANT
- target object of schema object privilege, GRANT
- truth table of the AND operator, Operators Used in Conditional Expressions
- truth table of the NOT operator, Operators Used in Conditional Expressions
- truth table of the OR operator, Operators Used in Conditional Expressions
- TAN function, TAN
- TANH function, TANH
- tbESQL, SQL Standard
- TIME literal, Datetime
- ANSI representation, Datetime
- TIMESTAMP literal, Datetime
- ANSI representation, Datetime
- TIMESTAMP WITH LOCAL TIME ZONE literal, Datetime
- TIMESTAMP WITH TIME ZONE literal, Datetime
- ANSI representation, Datetime
- TIMESTAMP_TO_TSN function, TIMESTAMP_TO_TSN
- TO_BINARY_DOUBLE function, TO_BINARY_DOUBLE
- TO_BINARY_FLOAT function, TO_BINARY_FLOAT
- TO_CHAR function (character), TO_CHAR(character)
- TO_CHAR function (datetime), TO_CHAR(datetime)
- TO_CHAR function (number), TO_CHAR(number)
- TO_CLOB function, TO_CLOB
- TO_DATE function, TO_DATE
- TO_DSINTERVAL function, TO_DSINTERVAL
- TO_LOB function, TO_LOB
- TO_MULTI_BYTE function, TO_MULTI_BYTE
- TO_NCHAR function, TO_NCHAR
- TO_NUMBER function, TO_NUMBER
- TO_SINGLE_BYTE function, TO_SINGLE_BYTE
- TO_TIME function, Datetime, TO_TIME
- TO_TIMESTAMP function, Datetime, TO_TIMESTAMP
- TO_TIMESTAMP_TZ function, Datetime, TO_TIMESTAMP_TZ
- TO_YMINTERVAL function, TO_YMINTERVAL
- transaction management language, Transaction and Session Management Language
- TRANSLATE function, TRANSLATE
- TRIM function, TRIM
- TRUNC function, Datetime
- TRUNC function (date), TRUNC(date)
- TRUNC function (number), TRUNC(number)
- TSN_TO_TIMESTAMP function, TSN_TO_TIMESTAMP
- TZ_OFFSET function, TZ_OFFSET
- TZ_SHIFT function, TZ_SHIFT
U
- UID function, UID
- UNION ALL operator, General Operators
- UNION operator, General Operators
- UNISTR function, UNISTR
- UNNEST hint, Query Transformations
- UPDATE, UPDATE
- UPDATEXML function, UPDATEXML
- UPPER function, UPPER
- USE_CONCAT, Others
- USE_HASH hint, Join Modes
- USE_MERGE hint, Join Modes
- USE_NL hint, Join Modes
- USE_NL_WITH_INDEX hint, Join Modes
- user, Schema Objects
- USER function, USER
- user-defined types, User-Defined
- USERENV function, USERENV
- USING
- inner join clause, SELECT
- outer join clause, SELECT
V
- VALUES clause
- INSERT, INSERT
- VAR_POP function, VAR_POP
- VAR_SAMP function, VAR_SAMP
- VARCHAR type, String
- VARCHAR2 type, String
- VARIANCE function, VARIANCE
- view, Views
- authority, Views
- base table, Views
- usage, Views
- VSIZE function, VSIZE
X
- XMLAGG function, XMLAGG
- XMLCAST function, XMLCAST
- XMLCDATA function, XMLCDATA
- XMLCOLATTVAL functionbv, XMLCOLATTVAL
- XMLCOMMENT function, XMLCOMMENT
- XMLCONCAT function, XMLCONCAT
- XMLELEMENT function, XMLELEMENT
- XMLEXISTS function, XMLEXISTS
- XMLFOREST function, XMLFOREST
- XMLPARSE function, XMLPARSE
- XMLPI function, XMLPI
- XMLQUERY function, XMLQUERY
- XMLROOT function, XMLROOT
- XMLSERIALIZE function, XMLSERIALIZE
- XMLTABLE function, XMLTABLE
- XMLTRANSFORM function, XMLTRANSFORM
- XMLTYPE type, Large Object