>>  <<  Ndx  Usr  Pri  JfC  LJ  Phr  Dic  Rel  Voc  !:  wd  Help  User

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

 


>>  <<  Ndx  Usr  Pri  JfC  LJ  Phr  Dic  Rel  Voc  !:  wd  Help  User