Elements Used in SQL Statements

The following elements are used in the SQL statements listed previously .

Element	Min	Core	Ext
approximate-numeric-literal ::= mantissaEexponent mantissa ::= exact-numeric-literal exponent ::= [+|-] unsigned-integer		X
approximate-numeric-type ::= FLOAT | DOUBLE PRECISION | REAL		X
argument-list ::= expression | expression, argument-list	X
base-table-identifier ::= user-defined-name	X
base-table-name ::= base-table-identifier	X
base-table-name ::= [user-name.]base-table-identifier		X
between-predicate ::= expression [NOT] BETWEEN expression AND expression		X
binary-literal ::= {implementation defined}			X
binary-type ::= BINARY (length) | VARBINARY (length) | LONG VARBINARY·			X
character ::= {any character in the implementor's character set}	X
character-string-literal :: = '{character}...'	X
character-string-type ::= CHARACTER(length) | CHAR(length)	X
character-string-type ::= CHARACTER(length) | CHAR(length) | CHARACTER VARYING(length) | VARCHAR(length)		X
character-string-type ::= CHARACTER(length) | CHAR(length) | CHARACTER VARYING(length) | VARCHAR(length) | LONG VARCHAR			X
column-identifier ::= user-defined-name	X
column-name ::= [table-name.]column-identifier	X
column-name ::= [{table-name | correlation-name}.]column-identifier		X
comparison-operator ::= < | > | <= | >= | = | <>	X
comparison-predicate ::= expression comparison-operator expression	X
comparison-predicate ::= expression comparison-operator {expression | (sub-query)}		X
correlation-name ::= user-defined-name		X
cursor-name ::= user-defined-name		X
data-type ::= character-string-type	X
data-type ::= character-string-type | exact-numeric-type | approximate-numeric-type		X
data-type ::= character-string-type | exact-numeric-type | approximate-numeric-type | binary-type | date-type | time-type | timestamp-type			X
date-literal ::= 'date-value'			X
date-separator ::= -			X
date-type ::= DATE			X
date-value ::= years-value date-separator months-value date-separator days-value			X
days-value ::= digit digit·	X
digit ::= 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9	X
dynamic-parameter ::= ?	X
exact-numeric-literal ::= [+|-] { unsigned-integer [.unsigned-integer ] | unsigned-integer. | .unsigned-integer }		X
exact-numeric-type ::= DECIMAL(precision,scale) | NUMERIC(precision,scale) | SMALLINT | INTEGER			X
exact-numeric-type ::= DECIMAL(precision,scale) | NUMERIC(precision,scale) | BIT | SMALLINT | INTEGER |BIGINT		X
exists-predicate ::= EXISTS ( sub-query )		X
expression ::= term | expression {+|-} term term ::= factor | term {*|/} factor factor ::= [+|-]primary primary ::= column-name | dynamic-parameter | literal (continued) | ( expression ) primary ::= column-name | dynamic-parameter | literal | set-function-reference | USER | ( expression ) primary ::= column-name | dynamic-parameter | literal | ODBC-scalar-function-extension | set-function-reference | USER | ( expression )	X	X	X
hours-value ::= digit digit			X
index-identifier ::= user-defined-name		X
index-name ::= [index-qualifier.]index-identifier		X
Index-qualifier ::= user-defined-name		X
in-predicate ::= expression [NOT] IN {(value {, value}...) | (sub-query)} value ::= literal | USER | dynamic-parameter		X