Index

Symbols

TO_DATE function, Datetime

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

B

base table, Views
BETWEEN condition, BETWEEN Condition
BINARY_DOUBLE Type, Number
BINARY_FLOAT type, Number
BITAND function, BITAND
BLOB type, Large Object

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

K

KURT function, KURT

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

Q

Query, SQL Queries, SELECT
query rewrite, Query Rewrite
accuracy, Enabling Query Rewrite
enabling query rewrite, Enabling Query Rewrite
rewrite method, Rewrite Methods

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

W

WAIT
FOR UPDATE clause, SELECT
WHERE clause, UPDATE
WITH CHECK OPTION
DELETE, DELETE
WITH CHECK OPTION clause
INSERT, INSERT
UPDATE, UPDATE
WITH READ ONLY
DELETE, DELETE
INSERT, INSERT
UPDATE, UPDATE
WITH READ ONLY clause
DELETE, DELETE

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