OpTypes

Documentation of 'org.hsqldb.OpTypes' Java class OpTypes

All Classes

Summary:
Nested |
Field |
Constr |
Method

Detail:
Field |
Constr |
Method

```
public interface OpTypes
```

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`ADD`
`static int`	`ALL_QUANTIFIED`
`static int`	`ALTERNATIVE`
`static int`	`AND`
`static int`	`ANY_QUANTIFIED`
`static int`	`ARRAY`
`static int`	`ARRAY_ACCESS`
`static int`	`ARRAY_AGG`
`static int`	`ARRAY_SUBQUERY`
`static int`	`ASTERISK`
`static int`	`AVG`
`static int`	`CASEWHEN`
`static int`	`CASEWHEN_COALESCE`
`static int`	`CAST`
`static int`	`COALESCE`
`static int`	`COLUMN`
`static int`	`CONCAT`
`static int`	`CONCAT_WS`
`static int`	`CONTAINS`
`static int`	`COUNT`
`static int`	`DEFAULT`
`static int`	`DIAGNOSTICS_VARIABLE`
`static int`	`DIVIDE`
`static int`	`DYNAMIC_PARAM`
`static int`	`EQUAL`
`static int`	`EVERY`
`static int`	`EXISTS`
`static int`	`FUNCTION`
`static int`	`GREATER`
`static int`	`GREATER_EQUAL`
`static int`	`GREATER_EQUAL_PRE`
`static int`	`GROUP_CONCAT`
`static int`	`IN`
`static int`	`IS_NOT_NULL`
`static int`	`IS_NULL`
`static int`	`LIKE`
`static int`	`LIKE_ARG`
`static int`	`LIMIT`
`static int`	`MATCH_FULL`
`static int`	`MATCH_PARTIAL`
`static int`	`MATCH_SIMPLE`
`static int`	`MATCH_UNIQUE_FULL`
`static int`	`MATCH_UNIQUE_PARTIAL`
`static int`	`MATCH_UNIQUE_SIMPLE`
`static int`	`MAX`
`static int`	`MEDIAN`
`static int`	`MIN`
`static int`	`MULTICOLUMN`
`static int`	`MULTIPLY`
`static int`	`MULTISET`
`static int`	`NEGATE`
`static int`	`NONE`
`static int`	`NOT`
`static int`	`NOT_DISTINCT`
`static int`	`NOT_EQUAL`
`static int`	`OR`
`static int`	`ORDER_BY`
`static int`	`OVERLAPS`
`static int`	`PARAMETER`
`static int`	`PREFIX`
`static int`	`RECURSIVE_SUBQUERY`
`static int`	`ROUTINE_FUNCTION`
`static int`	`ROW`
`static int`	`ROW_SUBQUERY`
`static int`	`ROWNUM`
`static int`	`SCALAR_SUBQUERY`
`static int`	`SEQUENCE`
`static int`	`SEQUENCE_CURRENT`
`static int`	`SIMPLE_COLUMN`
`static int`	`SMALLER`
`static int`	`SMALLER_EQUAL`
`static int`	`SOME`
`static int`	`SQL_FUNCTION`
`static int`	`STDDEV_POP`
`static int`	`STDDEV_SAMP`
`static int`	`SUBTRACT`
`static int`	`SUM`
`static int`	`TABLE`
`static int`	`TABLE_SUBQUERY`
`static int`	`TRANSITION_VARIABLE`
`static int`	`UNIQUE`
`static int`	`USER_AGGREGATE`
`static int`	`VALUE`
`static int`	`VALUELIST`
`static int`	`VAR_POP`
`static int`	`VAR_SAMP`
`static int`	`VARIABLE`
`static int`	`ZONE_MODIFIER`

- Field Detail
  - NONE
```
static final int NONE
```
    See Also:
    
    Constant Field Values
  - VALUE
```
static final int VALUE
```
    See Also:
    
    Constant Field Values
  - COLUMN
```
static final int COLUMN
```
    See Also:
    
    Constant Field Values
  - COALESCE
```
static final int COALESCE
```
    See Also:
    
    Constant Field Values
  - DEFAULT
```
static final int DEFAULT
```
    See Also:
    
    Constant Field Values
  - SIMPLE_COLUMN
```
static final int SIMPLE_COLUMN
```
    See Also:
    
    Constant Field Values
  - VARIABLE
```
static final int VARIABLE
```
    See Also:
    
    Constant Field Values
  - PARAMETER
```
static final int PARAMETER
```
    See Also:
    
    Constant Field Values
  - DYNAMIC_PARAM
```
static final int DYNAMIC_PARAM
```
    See Also:
    
    Constant Field Values
  - TRANSITION_VARIABLE
```
static final int TRANSITION_VARIABLE
```
    See Also:
    
    Constant Field Values
  - DIAGNOSTICS_VARIABLE
```
static final int DIAGNOSTICS_VARIABLE
```
    See Also:
    
    Constant Field Values
  - ASTERISK
```
static final int ASTERISK
```
    See Also:
    
    Constant Field Values
  - SEQUENCE
```
static final int SEQUENCE
```
    See Also:
    
    Constant Field Values
  - SEQUENCE_CURRENT
```
static final int SEQUENCE_CURRENT
```
    See Also:
    
    Constant Field Values
  - ROWNUM
```
static final int ROWNUM
```
    See Also:
    
    Constant Field Values
  - ARRAY
```
static final int ARRAY
```
    See Also:
    
    Constant Field Values
  - MULTISET
```
static final int MULTISET
```
    See Also:
    
    Constant Field Values
  - SCALAR_SUBQUERY
```
static final int SCALAR_SUBQUERY
```
    See Also:
    
    Constant Field Values
  - ROW_SUBQUERY
```
static final int ROW_SUBQUERY
```
    See Also:
    
    Constant Field Values
  - TABLE_SUBQUERY
```
static final int TABLE_SUBQUERY
```
    See Also:
    
    Constant Field Values
  - RECURSIVE_SUBQUERY
```
static final int RECURSIVE_SUBQUERY
```
    See Also:
    
    Constant Field Values
  - ROW
```
static final int ROW
```
    See Also:
    
    Constant Field Values
  - VALUELIST
```
static final int VALUELIST
```
    See Also:
    
    Constant Field Values
  - FUNCTION
```
static final int FUNCTION
```
    See Also:
    
    Constant Field Values
  - SQL_FUNCTION
```
static final int SQL_FUNCTION
```
    See Also:
    
    Constant Field Values
  - ROUTINE_FUNCTION
```
static final int ROUTINE_FUNCTION
```
    See Also:
    
    Constant Field Values
  - TABLE
```
static final int TABLE
```
    See Also:
    
    Constant Field Values
  - NEGATE
```
static final int NEGATE
```
    See Also:
    
    Constant Field Values
  - ADD
```
static final int ADD
```
    See Also:
    
    Constant Field Values
  - SUBTRACT
```
static final int SUBTRACT
```
    See Also:
    
    Constant Field Values
  - MULTIPLY
```
static final int MULTIPLY
```
    See Also:
    
    Constant Field Values
  - DIVIDE
```
static final int DIVIDE
```
    See Also:
    
    Constant Field Values
  - CONCAT
```
static final int CONCAT
```
    See Also:
    
    Constant Field Values
  - LIKE_ARG
```
static final int LIKE_ARG
```
    See Also:
    
    Constant Field Values
  - CASEWHEN_COALESCE
```
static final int CASEWHEN_COALESCE
```
    See Also:
    
    Constant Field Values
  - IS_NOT_NULL
```
static final int IS_NOT_NULL
```
    See Also:
    
    Constant Field Values
  - EQUAL
```
static final int EQUAL
```
    See Also:
    
    Constant Field Values
  - GREATER_EQUAL
```
static final int GREATER_EQUAL
```
    See Also:
    
    Constant Field Values
  - GREATER_EQUAL_PRE
```
static final int GREATER_EQUAL_PRE
```
    See Also:
    
    Constant Field Values
  - GREATER
```
static final int GREATER
```
    See Also:
    
    Constant Field Values
  - SMALLER
```
static final int SMALLER
```
    See Also:
    
    Constant Field Values
  - SMALLER_EQUAL
```
static final int SMALLER_EQUAL
```
    See Also:
    
    Constant Field Values
  - NOT_EQUAL
```
static final int NOT_EQUAL
```
    See Also:
    
    Constant Field Values
  - IS_NULL
```
static final int IS_NULL
```
    See Also:
    
    Constant Field Values
  - NOT
```
static final int NOT
```
    See Also:
    
    Constant Field Values
  - AND
```
static final int AND
```
    See Also:
    
    Constant Field Values
  - OR
```
static final int OR
```
    See Also:
    
    Constant Field Values
  - ALL_QUANTIFIED
```
static final int ALL_QUANTIFIED
```
    See Also:
    
    Constant Field Values
  - ANY_QUANTIFIED
```
static final int ANY_QUANTIFIED
```
    See Also:
    
    Constant Field Values
  - LIKE
```
static final int LIKE
```
    See Also:
    
    Constant Field Values
  - IN
```
static final int IN
```
    See Also:
    
    Constant Field Values
  - EXISTS
```
static final int EXISTS
```
    See Also:
    
    Constant Field Values
  - OVERLAPS
```
static final int OVERLAPS
```
    See Also:
    
    Constant Field Values
  - UNIQUE
```
static final int UNIQUE
```
    See Also:
    
    Constant Field Values
  - NOT_DISTINCT
```
static final int NOT_DISTINCT
```
    See Also:
    
    Constant Field Values
  - MATCH_SIMPLE
```
static final int MATCH_SIMPLE
```
    See Also:
    
    Constant Field Values
  - MATCH_PARTIAL
```
static final int MATCH_PARTIAL
```
    See Also:
    
    Constant Field Values
  - MATCH_FULL
```
static final int MATCH_FULL
```
    See Also:
    
    Constant Field Values
  - MATCH_UNIQUE_SIMPLE
```
static final int MATCH_UNIQUE_SIMPLE
```
    See Also:
    
    Constant Field Values
  - MATCH_UNIQUE_PARTIAL
```
static final int MATCH_UNIQUE_PARTIAL
```
    See Also:
    
    Constant Field Values
  - MATCH_UNIQUE_FULL
```
static final int MATCH_UNIQUE_FULL
```
    See Also:
    
    Constant Field Values
  - CONTAINS
```
static final int CONTAINS
```
    See Also:
    
    Constant Field Values
  - COUNT
```
static final int COUNT
```
    See Also:
    
    Constant Field Values
  - SUM
```
static final int SUM
```
    See Also:
    
    Constant Field Values
  - MIN
```
static final int MIN
```
    See Also:
    
    Constant Field Values
  - MAX
```
static final int MAX
```
    See Also:
    
    Constant Field Values
  - AVG
```
static final int AVG
```
    See Also:
    
    Constant Field Values
  - EVERY
```
static final int EVERY
```
    See Also:
    
    Constant Field Values
  - SOME
```
static final int SOME
```
    See Also:
    
    Constant Field Values
  - STDDEV_POP
```
static final int STDDEV_POP
```
    See Also:
    
    Constant Field Values
  - STDDEV_SAMP
```
static final int STDDEV_SAMP
```
    See Also:
    
    Constant Field Values
  - VAR_POP
```
static final int VAR_POP
```
    See Also:
    
    Constant Field Values
  - VAR_SAMP
```
static final int VAR_SAMP
```
    See Also:
    
    Constant Field Values
  - ARRAY_AGG
```
static final int ARRAY_AGG
```
    See Also:
    
    Constant Field Values
  - GROUP_CONCAT
```
static final int GROUP_CONCAT
```
    See Also:
    
    Constant Field Values
  - PREFIX
```
static final int PREFIX
```
    See Also:
    
    Constant Field Values
  - MEDIAN
```
static final int MEDIAN
```
    See Also:
    
    Constant Field Values
  - CONCAT_WS
```
static final int CONCAT_WS
```
    See Also:
    
    Constant Field Values
  - CAST
```
static final int CAST
```
    See Also:
    
    Constant Field Values
  - ZONE_MODIFIER
```
static final int ZONE_MODIFIER
```
    See Also:
    
    Constant Field Values
  - CASEWHEN
```
static final int CASEWHEN
```
    See Also:
    
    Constant Field Values
  - ORDER_BY
```
static final int ORDER_BY
```
    See Also:
    
    Constant Field Values
  - LIMIT
```
static final int LIMIT
```
    See Also:
    
    Constant Field Values
  - ALTERNATIVE
```
static final int ALTERNATIVE
```
    See Also:
    
    Constant Field Values
  - MULTICOLUMN
```
static final int MULTICOLUMN
```
    See Also:
    
    Constant Field Values
  - USER_AGGREGATE
```
static final int USER_AGGREGATE
```
    See Also:
    
    Constant Field Values
  - ARRAY_ACCESS
```
static final int ARRAY_ACCESS
```
    See Also:
    
    Constant Field Values
  - ARRAY_SUBQUERY
```
static final int ARRAY_SUBQUERY
```
    See Also:
    
    Constant Field Values

Skip navigation links

All Classes

Summary:
Nested |
Field |
Constr |
Method

Detail:
Field |
Constr |
Method

Interface OpTypes

Field Summary

Field Detail

NONE

VALUE

COLUMN

COALESCE

DEFAULT

SIMPLE_COLUMN

VARIABLE

PARAMETER

DYNAMIC_PARAM

TRANSITION_VARIABLE

DIAGNOSTICS_VARIABLE

ASTERISK

SEQUENCE

SEQUENCE_CURRENT

ROWNUM

ARRAY

MULTISET

SCALAR_SUBQUERY

ROW_SUBQUERY

TABLE_SUBQUERY

RECURSIVE_SUBQUERY

ROW

VALUELIST

FUNCTION

SQL_FUNCTION

ROUTINE_FUNCTION

TABLE

NEGATE

ADD

SUBTRACT

MULTIPLY

DIVIDE

CONCAT

LIKE_ARG

CASEWHEN_COALESCE

IS_NOT_NULL

EQUAL

GREATER_EQUAL

GREATER_EQUAL_PRE

GREATER

SMALLER

SMALLER_EQUAL

NOT_EQUAL

IS_NULL

NOT

AND

OR

ALL_QUANTIFIED

ANY_QUANTIFIED

LIKE

IN

EXISTS

OVERLAPS

UNIQUE

NOT_DISTINCT

MATCH_SIMPLE

MATCH_PARTIAL

MATCH_FULL

MATCH_UNIQUE_SIMPLE

MATCH_UNIQUE_PARTIAL

MATCH_UNIQUE_FULL

CONTAINS

COUNT

SUM

MIN

MAX

AVG

EVERY

SOME

STDDEV_POP

STDDEV_SAMP

VAR_POP

VAR_SAMP

ARRAY_AGG

GROUP_CONCAT

PREFIX

MEDIAN