-
Language:
English
-
Language:
English
Red Hat Training
A Red Hat training course is available for Red Hat JBoss Data Virtualization
A.3. Non-Reserved Keywords
|
Keyword
|
Usage
|
|---|---|
|
ACCESSPATTERN
|
other constraints , non-reserved identifier
|
|
ARRAYTABLE
|
array table , non-reserved identifier
|
|
AUTO_INCREMENT
|
table element , non-reserved identifier
|
|
AVG
|
standard aggregate function , non-reserved identifier
|
|
CHAIN
|
sql exception , non-reserved identifier
|
|
COLUMNS
|
array table , non-reserved identifier , object table , text table , xml table
|
|
CONTENT
|
non-reserved identifier , xml parse , xml serialize
|
|
COUNT
|
standard aggregate function , non-reserved identifier
|
|
DELIMITER
|
non-reserved identifier , text aggregate function , text table
|
|
DENSE_RANK
|
analytic aggregate function , non-reserved identifier
|
|
DISABLED
|
alter , non-reserved identifier
|
|
DOCUMENT
|
non-reserved identifier , xml parse , xml serialize
|
|
EMPTY
|
non-reserved identifier , xml query
|
|
ENABLED
|
alter , non-reserved identifier
|
|
ENCODING
|
non-reserved identifier , text aggregate function , xml serialize
|
|
EVERY
|
standard aggregate function , non-reserved identifier
|
|
EXCEPTION
|
compound statement , declare statement , non-reserved identifier
|
|
EXCLUDING
|
non-reserved identifier , xml serialize
|
|
EXTRACT
|
function , non-reserved identifier
|
|
FIRST
|
fetch clause , non-reserved identifier , sort specification
|
|
HEADER
|
non-reserved identifier , text aggregate function , text table
|
|
INCLUDING
|
non-reserved identifier , xml serialize
|
|
INDEX
|
other constraints , table element , non-reserved identifier
|
|
INSTEAD
|
alter , create trigger , non-reserved identifier
|
|
JSONARRAY_AGG
|
non-reserved identifier , ordered aggregate function
|
|
JSONOBJECT
|
json object , non-reserved identifier
|
|
KEY
|
table element , create temporary table , foreign key , non-reserved identifier , primary key
|
|
LAST
|
non-reserved identifier , sort specification
|
|
MAX
|
standard aggregate function , non-reserved identifier
|
|
MIN
|
standard aggregate function , non-reserved identifier
|
|
NAME
|
function , non-reserved identifier , xml element
|
|
NAMESPACE
|
option namespace , non-reserved identifier
|
|
NEXT
|
fetch clause , non-reserved identifier
|
|
NULLS
|
non-reserved identifier , sort specification
|
|
OBJECTTABLE
|
non-reserved identifier , object table
|
|
ORDINALITY
|
non-reserved identifier , xml table column
|
|
PASSING
|
non-reserved identifier , object table , xml query , xml table
|
|
PATH
|
non-reserved identifier , xml table column
|
|
QUERYSTRING
|
non-reserved identifier , querystring function
|
|
QUOTE
|
non-reserved identifier , text aggregate function , text table
|
|
RAISE
|
non-reserved identifier , raise statement
|
|
RANK
|
analytic aggregate function , non-reserved identifier
|
|
RESULT
|
non-reserved identifier , procedure parameter
|
|
ROW_NUMBER
|
analytic aggregate function , non-reserved identifier
|
|
SELECTOR
|
non-reserved identifier , text table column , text table
|
|
SERIAL
|
non-reserved identifier , temporary table element
|
|
SKIP
|
non-reserved identifier , text table
|
|
SQL_TSI_DAY
|
time interval , non-reserved identifier
|
|
SQL_TSI_FRAC_SECOND
|
time interval , non-reserved identifier
|
|
SQL_TSI_HOUR
|
time interval , non-reserved identifier
|
|
SQL_TSI_MINUTE
|
time interval , non-reserved identifier
|
|
SQL_TSI_MONTH
|
time interval , non-reserved identifier
|
|
SQL_TSI_QUARTER
|
time interval , non-reserved identifier
|
|
SQL_TSI_SECOND
|
time interval , non-reserved identifier
|
|
SQL_TSI_WEEK
|
time interval , non-reserved identifier
|
|
SQL_TSI_YEAR
|
time interval , non-reserved identifier
|
|
STDDEV_POP
|
standard aggregate function , non-reserved identifier
|
|
STDDEV_SAMP
|
standard aggregate function , non-reserved identifier
|
|
SUBSTRING
|
function , non-reserved identifier
|
|
SUM
|
standard aggregate function , non-reserved identifier
|
|
TEXTAGG
|
non-reserved identifier , text aggregate function
|
|
TEXTTABLE
|
non-reserved identifier , text table
|
|
TIMESTAMPADD
|
function , non-reserved identifier
|
|
TIMESTAMPDIFF
|
function , non-reserved identifier
|
|
TO_BYTES
|
function , non-reserved identifier
|
|
TO_CHARS
|
function , non-reserved identifier
|
|
TRIM
|
function , non-reserved identifier , text table column
|
|
VARIADIC
|
non-reserved identifier , procedure parameter
|
|
VAR_POP
|
standard aggregate function , non-reserved identifier
|
|
VAR_SAMP
|
standard aggregate function , non-reserved identifier
|
|
VERSION
|
non-reserved identifier , xml serialize
|
|
VIEW
|
alter , alter options , create table , non-reserved identifier
|
|
WELLFORMED
|
non-reserved identifier , xml parse
|
|
WIDTH
|
non-reserved identifier , text table column
|
|
XMLDECLARATION
|
non-reserved identifier , xml serialize
|
