A.5. Tokens

all in group identifier

< identifier > < period > < star >

all in group

binary string literal

"X" | "x" "\'" (< hexit > < hexit >)+ "\'"

non numeric literal

colon

":"

statement

comma

","

alter options list , column list , create procedure , typed element list , create table body , create temporary table , derived column list , sql exception named parameter list , expression list , from clause , function limit clause , object table , option clause , options clause , order by clause , data type , query expression , querystring function select clause , set clause list , in predicate , text aggreate function , text table , xml attributes , xml element , xml forest , xml namespaces , xml query , xml table

concat_op

"||"

common value expression

decimal numeric literal

(< digit >)* < period > < unsigned integer literal >

unsigned numeric literal

digit

["0"-"9"]

dollar

"$"

unsigned value expression primary

eq

"="

assignment statement , callable statement , declare statement , named parameter list , comparison operator , set clause list

escaped function

"{" "fn"

unsigned value expression primary

escaped join

"{" "oj"

table reference

escaped type

"{" ("d" | "t" | "ts" | "b")

non numeric literal

approximate numeric literal

< digit > < period > < unsigned integer literal > ["e","E"] (< plus > | < minus >)? < unsigned integer literal >

unsigned numeric literal

ge

">="

comparison operator

gt

">"

named parameter list , comparison operator

hexit

["a"-"f","A"-"F"] | < digit >

identifier

< quoted_id > (< period > < quoted_id >)*

identifier , unsigned value expression primary

id_part

("@" | "#" | < letter >) (< letter > | "_" | < digit >)*

lbrace

"{"

callable statement , match predicate

le

"<="

comparison operator

letter

["a"-"z","A"-"Z"] | ["\u0153"-"\ufffd"]

lparen

"("

standard aggregate function , alter options list , analytic aggregate function , array table , callable statement , column list , other constraints , create procedure , create table body , create temporary table , filter clause , function , if statement , insert statement , json object , loop statement , object table , options clause , ordered aggreate function , data type , query primary , querystring function , in predicate , call statement , subquery , table subquery , table primary , text aggregate function , text table , unsigned value expression primary , while statement , window specification , with list element , xml attributes , xml element , xml forest , xml namespaces , xml parse , xml query , xml serialize , xml table

lsbrace

"["

unsigned value expression primary

lt

"<"

comparison operator

minus

"-"

plus or minus

ne

"<>"

comparison operator

ne2

"!="

comparison operator

period

"."

plus

"+"

plus or minus

qmark

"?"

callable statement , integer parameter , unsigned value expression primary

quoted_id

< id_part > | "\"" ("\"\"" | ~["\""])+ "\""

rbrace

"}"

callable statement , match predicate , non numeric literal , table reference , unsigned value expression primary

rparen

")"

standard aggregate function , alter options list , analytic aggregate function , array table , callable statement , column list , other constraints , create procedure , create table body , create temporary table , filter clause , function , if statement , insert statement , json object , loop statement , object table , options clause , ordered aggregate function , data type , query primary , querystring function , in predicate , call statement , subquery , table subquery , table primary , text aggregate function , text table , unsigned value expression primary , while statement , window specification , with list element , xml attributes , xml element , xml forest , xml namespaces , xml parse , xml query , xml serialize , xml table

rsbrace

"]"

unsigned value expression primary

semicolon

";"

ddl statement , delimited statement

slash

"/"

star or slash

star

"*"

standard aggregate function , dynamic data statement , select clause , star or slash

string literal

("N" | "E")? "\'" ("\'\'" | ~["\'"])* "\'"

string

unsigned integer literal

(< digit >)+

unsigned integer , unsigned numeric literal