(
)
- (
NOT (
)
(
>
>=
=
!=
<
<=
+
-
*
/
||
)
LIKE
NOT LIKE
LIKE2
NOT LIKE2
LIKE4
NOT LIKE4
LIKEC
NOT LIKEC
ESCAPE
MEMBER OF
NOT MEMBER OF
SUBMULTISET OF
NOT SUBMULTISET OF
IS NULL
IS NOT NULL
IS
NAN
NOT NAN
INFINITE
NOT INFINITE
IS
A SET
NOT A SET
EMPTY
NOT EMPTY
IS
NOT
OF TYPE (
,
)
ONLY
CAST(
)
MULTISET
AS
TRIM(
FROM
)
(
,
)
USING
EXTRACT (
FROM
)
(
)
GROUP_ID()
LNNVL
NOT REGEXP_LIKE
(
,
)
(
)
()
VALUE("
")
(
,
)
COUNT(
*
*
)
(
)
FIRST_VALUE
LAST_VALUE
(
IGNORE NULLS)
(
)
(
,
)
AVG(
)
DISTINCT
ROW_NUMBER()
KEEP (
)
DENSE_RANK FIRST
OVER (
)
WITHIN GROUP (
)
PARTITION BY (
,
)
TABLE (
)
.
(
,
)
(
,
)
"
".
"
".
"
"
.
"
"
"
"
"
"
.
"
".
(+)
"
"
"
".
"
"
'
'
VERSIONS BETWEEN
TIMESTAMP
AND
SCN
AND
AS OF
TIMESTAMP
DATE
'
'
TIMESTAMP
'
'
INTERVAL '
-
YEAR
'
YEAR
MONTH
YEAR
MONTH
TO MONTH
DAY
'
DAY
HOUR
MINUTE
SECOND
SECOND
MINUTE
HOUR
DAY
TO
N
N
.
00
0
-
:
00
MONTH
HOUR
MINUTE
SECOND
Y
Y
2
(
,
)
(
)
(
)
YEAR
(
)
TO MONTH
DAY
(
)
TO SECOND
(
)
(
AT
LOCAL
TIME ZONE
DBTIMEZONE
SESSIONTIMEZONE
'
'
'
-
00
:
00
'
)
CASE
WHEN
THEN
ELSE
END
1
(
)
0
(
UNION ALL
)
WITH
(
"
")
",
AS
,
SEARCH
DEPTH FIRST BY
BREADTH FIRST BY
"
"
,
SET "
"
CYCLE
"
"
,
SET "
" TO
DEFAULT
SELECT
UNIQUE
1
"
"
,
*
/*+
(
@
)
*/
"
"
FROM
1
(+)
"
"
,
(
JOIN
)
"
".
"
"
"
"
("
")
LEFT OUTER
FULL OUTER
RIGHT OUTER
NATURAL INNER
ON
USING (
,
)
WHERE
CONNECT BY
START WITH
NOCYCLE
(
)
NOT EXISTS
ORDER
SIBLINGS
BY
,
DESC
DESC NULLS LAST
ASC NULLS FIRST
GROUP BY
,
GROUPING SETS
BETWEEN
AND
CURRENT ROW
(
,
)