Package org.apache.empire.dbms

Enum DBSqlPhrase

java.lang.Object
java.lang.Enum<DBSqlPhrase>
org.apache.empire.dbms.DBSqlPhrase
All Implemented Interfaces:
Serializable, Comparable<DBSqlPhrase>, java.lang.constant.Constable
public enum DBSqlPhrase extends Enum<DBSqlPhrase>
Enum for all SQL phrases that may be supplied by the dbms The phase may consist of the following placeholders: ? = the expression on which the function is applied (usually a column expression) {[param-index]:[DataType]} = a function parameter. The DataType name, if supplied, must match the name of a DataType enum value.
Author:
rainer

  • Enum Constant Details

    • SQL_NULL

      public static final DBSqlPhrase SQL_NULL

    • SQL_PARAMETER

      public static final DBSqlPhrase SQL_PARAMETER

    • SQL_RENAME_TABLE

      public static final DBSqlPhrase SQL_RENAME_TABLE

    • SQL_RENAME_COLUMN

      public static final DBSqlPhrase SQL_RENAME_COLUMN

    • SQL_QUOTES_OPEN

      public static final DBSqlPhrase SQL_QUOTES_OPEN

    • SQL_QUOTES_CLOSE

      public static final DBSqlPhrase SQL_QUOTES_CLOSE

    • SQL_CONCAT_EXPR

      public static final DBSqlPhrase SQL_CONCAT_EXPR

    • SQL_PSEUDO_TABLE

      public static final DBSqlPhrase SQL_PSEUDO_TABLE

    • SQL_BOOLEAN_TRUE

      public static final DBSqlPhrase SQL_BOOLEAN_TRUE

    • SQL_BOOLEAN_FALSE

      public static final DBSqlPhrase SQL_BOOLEAN_FALSE

    • SQL_CURRENT_DATE

      public static final DBSqlPhrase SQL_CURRENT_DATE

    • SQL_DATE_TEMPLATE

      public static final DBSqlPhrase SQL_DATE_TEMPLATE

    • SQL_CURRENT_TIME

      public static final DBSqlPhrase SQL_CURRENT_TIME

    • SQL_TIME_TEMPLATE

      public static final DBSqlPhrase SQL_TIME_TEMPLATE

    • SQL_CURRENT_DATETIME

      public static final DBSqlPhrase SQL_CURRENT_DATETIME

    • SQL_DATETIME_TEMPLATE

      public static final DBSqlPhrase SQL_DATETIME_TEMPLATE

    • SQL_CURRENT_TIMESTAMP

      public static final DBSqlPhrase SQL_CURRENT_TIMESTAMP

    • SQL_TIMESTAMP_TEMPLATE

      public static final DBSqlPhrase SQL_TIMESTAMP_TEMPLATE

    • SQL_DATE_PATTERN

      public static final DBSqlPhrase SQL_DATE_PATTERN

    • SQL_TIME_PATTERN

      public static final DBSqlPhrase SQL_TIME_PATTERN

    • SQL_DATETIME_PATTERN

      public static final DBSqlPhrase SQL_DATETIME_PATTERN

    • SQL_TIMESTAMP_PATTERN

      public static final DBSqlPhrase SQL_TIMESTAMP_PATTERN

    • SQL_FUNC_COALESCE

      public static final DBSqlPhrase SQL_FUNC_COALESCE

    • SQL_FUNC_SUBSTRING

      public static final DBSqlPhrase SQL_FUNC_SUBSTRING

    • SQL_FUNC_SUBSTRINGEX

      public static final DBSqlPhrase SQL_FUNC_SUBSTRINGEX

    • SQL_FUNC_REPLACE

      public static final DBSqlPhrase SQL_FUNC_REPLACE

    • SQL_FUNC_REVERSE

      public static final DBSqlPhrase SQL_FUNC_REVERSE

    • SQL_FUNC_STRINDEX

      public static final DBSqlPhrase SQL_FUNC_STRINDEX

    • SQL_FUNC_STRINDEXFROM

      public static final DBSqlPhrase SQL_FUNC_STRINDEXFROM

    • SQL_FUNC_LENGTH

      public static final DBSqlPhrase SQL_FUNC_LENGTH

    • SQL_FUNC_UPPER

      public static final DBSqlPhrase SQL_FUNC_UPPER

    • SQL_FUNC_LOWER

      public static final DBSqlPhrase SQL_FUNC_LOWER

    • SQL_FUNC_TRIM

      public static final DBSqlPhrase SQL_FUNC_TRIM

    • SQL_FUNC_LTRIM

      public static final DBSqlPhrase SQL_FUNC_LTRIM

    • SQL_FUNC_RTRIM

      public static final DBSqlPhrase SQL_FUNC_RTRIM

    • SQL_FUNC_ESCAPE

      public static final DBSqlPhrase SQL_FUNC_ESCAPE

    • SQL_FUNC_CONCAT

      public static final DBSqlPhrase SQL_FUNC_CONCAT

    • SQL_FUNC_CONTAINS

      public static final DBSqlPhrase SQL_FUNC_CONTAINS

    • SQL_FUNC_ABS

      public static final DBSqlPhrase SQL_FUNC_ABS

    • SQL_FUNC_ROUND

      public static final DBSqlPhrase SQL_FUNC_ROUND

    • SQL_FUNC_TRUNC

      public static final DBSqlPhrase SQL_FUNC_TRUNC

    • SQL_FUNC_FLOOR

      public static final DBSqlPhrase SQL_FUNC_FLOOR

    • SQL_FUNC_CEILING

      public static final DBSqlPhrase SQL_FUNC_CEILING

    • SQL_FUNC_MOD

      public static final DBSqlPhrase SQL_FUNC_MOD

    • SQL_FUNC_FORMAT

      public static final DBSqlPhrase SQL_FUNC_FORMAT

    • SQL_FUNC_DAY

      public static final DBSqlPhrase SQL_FUNC_DAY

    • SQL_FUNC_MONTH

      public static final DBSqlPhrase SQL_FUNC_MONTH

    • SQL_FUNC_YEAR

      public static final DBSqlPhrase SQL_FUNC_YEAR

    • SQL_FUNC_SUM

      public static final DBSqlPhrase SQL_FUNC_SUM

    • SQL_FUNC_MAX

      public static final DBSqlPhrase SQL_FUNC_MAX

    • SQL_FUNC_MIN

      public static final DBSqlPhrase SQL_FUNC_MIN

    • SQL_FUNC_AVG

      public static final DBSqlPhrase SQL_FUNC_AVG

    • SQL_FUNC_STRAGG

      public static final DBSqlPhrase SQL_FUNC_STRAGG

    • SQL_FUNC_DECODE

      public static final DBSqlPhrase SQL_FUNC_DECODE

    • SQL_FUNC_DECODE_SEP

      public static final DBSqlPhrase SQL_FUNC_DECODE_SEP

    • SQL_FUNC_DECODE_PART

      public static final DBSqlPhrase SQL_FUNC_DECODE_PART

    • SQL_FUNC_DECODE_ELSE

      public static final DBSqlPhrase SQL_FUNC_DECODE_ELSE

  • Method Details

    • values

      public static DBSqlPhrase[] values()
      Returns an array containing the constants of this enum type, in the order they are declared.
      Returns:
      an array containing the constants of this enum type, in the order they are declared

    • valueOf

      public static DBSqlPhrase valueOf(String name)
      Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
      Parameters:
      name - the name of the enum constant to be returned.
      Returns:
      the enum constant with the specified name
      Throws:
      IllegalArgumentException - if this enum type has no constant with the specified name
      NullPointerException - if the argument is null

    • getFuncName

      public String getFuncName()

    • getSqlDefault

      public String getSqlDefault()

    • isAggregate

      public boolean isAggregate()