EDataType (General SQL Parser Java Library Core 4.1.0.5 API)

Object
- Enum<EDataType>
- - gudusoft.gsqlparser.EDataType

All Implemented Interfaces:

Serializable, Comparable<EDataType>
```
public enum EDataType
extends Enum<EDataType>
```
Since:

v1.4.3.0

Enum Constant Summary

Enum Constants
Enum Constant and Description
`agg_state_t`
`alphanum_t`
`anyType_t`
`array_t`
`bfile_t`
`bigint_t` ansi2003: bigint postgresql
`bignumeric_t`
`bigserial_t`
`binary_double_t`
`binary_float_t`
`binary_integer_t` plsql binary_integer
`binary_large_object_t` binary large object Databases: DB2, teradata
`binary_t` ansi2003: blob
`bintext_t`
`bit_t`
`bit_varying_t`
`bitmap_t`
`blob_t`
`bool_t` bool, boolean, ansi2003: boolean
`boolean_t`
`box_t`
`byte_t` teradata: byte
`bytea_t`
`byteint_t` teradata byteint
`char_byte_t`
`char_for_bit_data_t`
`char_large_object_t` teradata: character large object
`char_t`
`character_t` char, character, ansi2003: character
`cidr_t`
`circle_t`
`clob_t`
`collection_data_types_collection_t`
`collection_data_types_list_t`
`collection_data_types_multiset_t`
`collection_data_types_set_t`
`currency_t`
`cursor_t`
`datalink_t`
`date_t`
`datetime_t` ansi2003: timestamp
`datetime2_t`
`datetimeoffset_t`
`dbclob_t` ansi2003: nclob Databases: DB2
`dec_t`
`decfloat_t`
`decimal_t` dec,decimal, ansi2003: decimal
`double_precision_t`
`double_t` double, double precision, ansi2003: float
`enum_t`
`fixed_t`
`float_t`
`float4_t`
`float64_t`
`float8_t`
`generic_t` user defined datetype
`geography_t`
`geometry_t`
`graphic_t` ansi2003 blob
`hierarchyid_t`
`hll_t`
`idssecuritylabel_t`
`image_t`
`inet_t`
`int_t`
`int2_t`
`int4_t`
`int64_t`
`int8_t`
`integer_t` int, integer, ansi2003: integer
`interval_day_t` teradata: interval day
`interval_day_to_hour_t` teradata: interval day to hour
`interval_day_to_minute_t` teradata: interval day to minute
`interval_day_to_second_t`
`interval_hour_t` teradata: interval hour
`interval_hour_to_minute_t` teradata: interval hour to minute
`interval_hour_to_second_t` teradata: interval hour to second
`interval_minute_t` teradata: interval minute
`interval_minute_to_second_t` teradata: interval minute to second
`interval_month_t` teradata: interval month
`interval_second_t` teradata:interval second
`interval_t` Postgresql
`interval_year_t` teradata interval year.
`interval_year_to_month_t`
`ipv4_t`
`ipv6_t`
`json_t`
`jsonb_t`
`largeint_t`
`line_t`
`listType_t`
`long_byte_t`
`long_raw_t` ansi2003: blob
`long_t`
`long_varbinary_t` long varbinary, mysql MySQL Connector/ODBC defines BLOB values as LONGVARBINARY and TEXT values as LONGVARCHAR.
`long_varchar_t`
`long_vargraphic_t`
`longblob_t`
`longtext_t`
`lseg_t`
`lvarbinary_t`
`lvarchar_t`
`macaddr_t`
`map_t`
`mapType_t`
`mediumblob_t`
`mediumint_t` mediumint, middleint(MySQL) , ansi2003: int
`mediumtext_t`
`money_t`
`natural_t`
`naturaln_t`
`nchar_t` nchar, national char, national character,ansi2003: national character
`ncharacter_t`
`nclob_t` ansi2003: nclob
`no_typename_t` datatypeAttribute in cast function will be treated as a datatype without typename RW_CAST ( expr AS datatypeAttribute )
`ntext_t` ntext, national text, ansi2003: nclob
`number_t` number, num
`numeric_t` ansi2003: numeric
`nvarchar_t` national_char_varying,nchar_varying,nvarchar, ansi2003: national character varying
`nvarchar2_t` nvarchar2(n)
`object_t`
`oid_t`
`path_t`
`period_t` teradata: period(n)
`pls_integer_t` plsql pls_integer
`point_t`
`polygon_t`
`positive_t`
`positiven_t`
`quantile_state_t`
`range_t`
`raw_t`
`real_t` ansi2003: real
`refcursor_t`
`resultset_t`
`row_data_types_t`
`row_t`
`rowid_t`
`rowversion_t`
`seconddate_t`
`self_t`
`serial_t`
`serial8_t`
`set_t` MySQL: set
`shorttext_t`
`signtype_t`
`simple_integer_t`
`smalldatetime_t`
`smalldec_t`
`smallfloat_t`
`smallint_t` ansi2003: smallint
`smallmoney_t`
`sql_variant_t`
`st_geometry_t`
`string_t`
`struct_t`
`structType_t` Deprecated. As of v2.3.4.6, please use `struct_t` instead
`table_t`
`td_anytype_t`
`text_t`
`time_t` ansi2003: time
`time_with_time_zone_t` teradata: time with time zone
`time_without_time_zone_t`
`timentz_t`
`timespan_t`
`timestamp_t`
`timestamp_with_local_time_zone_t` timestamp with local time zone, Database: Oracle,SQL Server
`timestamp_with_time_zone_t` timestamp with time zone, timestamptz, ansi2003: timestamp with time zone
`timestamp_without_time_zone_t`
`timetz_t` time with time zone, ansi2003: time with time zone Databases: teradata
`tinyblob_t`
`tinyint_t`
`tinytext_t`
`unionType_t`
`uniqueidentifier_t`
`unknown_t`
`unsigned_int_t`
`urowid_t`
`varbinary_t` ansi2003: blob
`varbit_t` netezza, bit varying
`varbyte_t` teradata: varbyte
`varchar_for_bit_data_t`
`varchar_t` varchar, char varying, character varying, ansi2003:character varying(n)
`varchar2_t` ansi2003: character varying
`vargraphic_t` ansi2003: nchar varying
`variant_t`
`varray_t`
`vector_t`
`xml_t`
`xmltype_t`
`year_t`

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method and Description
`static EDataType`	`valueOf(String name)` Returns the enum constant of this type with the specified name.
`static EDataType[]`	`values()` Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class Object
getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

unknown_t

public static final EDataType unknown_t

generic_t

public static final EDataType generic_t

user defined datetype

bfile_t
```
public static final EDataType bfile_t
```

bigint_t
```
public static final EDataType bigint_t
```
ansi2003: bigint postgresql

bignumeric_t

public static final EDataType bignumeric_t

binary_t
```
public static final EDataType binary_t
```
ansi2003: blob

binary_float_t

public static final EDataType binary_float_t

binary_double_t

public static final EDataType binary_double_t

binary_integer_t

public static final EDataType binary_integer_t

plsql binary_integer

binary_large_object_t
```
public static final EDataType binary_large_object_t
```
binary large object Databases: DB2, teradata

bit_t
```
public static final EDataType bit_t
```

bit_varying_t

public static final EDataType bit_varying_t

blob_t
```
public static final EDataType blob_t
```

bool_t
```
public static final EDataType bool_t
```
bool, boolean, ansi2003: boolean

box_t
```
public static final EDataType box_t
```

byte_t
```
public static final EDataType byte_t
```
teradata: byte

bytea_t
```
public static final EDataType bytea_t
```

byteint_t

public static final EDataType byteint_t

teradata byteint

character_t
```
public static final EDataType character_t
```
char, character, ansi2003: character

char_t
```
public static final EDataType char_t
```

char_for_bit_data_t

public static final EDataType char_for_bit_data_t

char_large_object_t

public static final EDataType char_large_object_t

teradata: character large object

cidr_t
```
public static final EDataType cidr_t
```

circle_t
```
public static final EDataType circle_t
```

clob_t
```
public static final EDataType clob_t
```

cursor_t
```
public static final EDataType cursor_t
```

datalink_t

public static final EDataType datalink_t

date_t
```
public static final EDataType date_t
```

datetime_t

public static final EDataType datetime_t

ansi2003: timestamp

datetimeoffset_t

public static final EDataType datetimeoffset_t

datetime2_t

public static final EDataType datetime2_t

dbclob_t
```
public static final EDataType dbclob_t
```
ansi2003: nclob Databases: DB2

decimal_t

public static final EDataType decimal_t

dec,decimal, ansi2003: decimal

dec_t
```
public static final EDataType dec_t
```

double_t
```
public static final EDataType double_t
```
double, double precision, ansi2003: float

enum_t
```
public static final EDataType enum_t
```

float_t
```
public static final EDataType float_t
```

float4_t
```
public static final EDataType float4_t
```

float8_t
```
public static final EDataType float8_t
```

graphic_t

public static final EDataType graphic_t

ansi2003 blob

geography_t

public static final EDataType geography_t

geometry_t

public static final EDataType geometry_t

hierarchyid_t

public static final EDataType hierarchyid_t

image_t
```
public static final EDataType image_t
```

inet_t
```
public static final EDataType inet_t
```

integer_t

public static final EDataType integer_t

int, integer, ansi2003: integer

int_t
```
public static final EDataType int_t
```

int2_t
```
public static final EDataType int2_t
```

int4_t
```
public static final EDataType int4_t
```

interval_t

public static final EDataType interval_t

Postgresql

interval_day_t

public static final EDataType interval_day_t

teradata: interval day

interval_day_to_hour_t

public static final EDataType interval_day_to_hour_t

teradata: interval day to hour

interval_day_to_minute_t

public static final EDataType interval_day_to_minute_t

teradata: interval day to minute

interval_day_to_second_t

public static final EDataType interval_day_to_second_t

interval_hour_t

public static final EDataType interval_hour_t

teradata: interval hour

interval_hour_to_minute_t

public static final EDataType interval_hour_to_minute_t

teradata: interval hour to minute

interval_hour_to_second_t

public static final EDataType interval_hour_to_second_t

teradata: interval hour to second

interval_minute_t

public static final EDataType interval_minute_t

teradata: interval minute

interval_minute_to_second_t
```
public static final EDataType interval_minute_to_second_t
```
teradata: interval minute to second

interval_month_t

public static final EDataType interval_month_t

teradata: interval month

interval_second_t

public static final EDataType interval_second_t

teradata:interval second

interval_year_t

public static final EDataType interval_year_t

teradata interval year.

interval_year_to_month_t

public static final EDataType interval_year_to_month_t

line_t
```
public static final EDataType line_t
```

long_t
```
public static final EDataType long_t
```

long_varchar_t

public static final EDataType long_varchar_t

long_varbinary_t
```
public static final EDataType long_varbinary_t
```
long varbinary, mysql MySQL Connector/ODBC defines BLOB values as LONGVARBINARY and TEXT values as LONGVARCHAR.

longblob_t

public static final EDataType longblob_t

long_raw_t

public static final EDataType long_raw_t

ansi2003: blob

long_vargraphic_t

public static final EDataType long_vargraphic_t

longtext_t

public static final EDataType longtext_t

lseg_t
```
public static final EDataType lseg_t
```

macaddr_t

public static final EDataType macaddr_t

mediumblob_t

public static final EDataType mediumblob_t

mediumint_t
```
public static final EDataType mediumint_t
```
mediumint, middleint(MySQL) , ansi2003: int

mediumtext_t

public static final EDataType mediumtext_t

money_t
```
public static final EDataType money_t
```

nvarchar_t
```
public static final EDataType nvarchar_t
```
national_char_varying,nchar_varying,nvarchar, ansi2003: national character varying

nchar_t
```
public static final EDataType nchar_t
```
nchar, national char, national character,ansi2003: national character

ncharacter_t

public static final EDataType ncharacter_t

nclob_t
```
public static final EDataType nclob_t
```
ansi2003: nclob

ntext_t
```
public static final EDataType ntext_t
```
ntext, national text, ansi2003: nclob

nvarchar2_t

public static final EDataType nvarchar2_t

nvarchar2(n)

number_t
```
public static final EDataType number_t
```
number, num

numeric_t

public static final EDataType numeric_t

ansi2003: numeric

oid_t
```
public static final EDataType oid_t
```

path_t
```
public static final EDataType path_t
```

period_t
```
public static final EDataType period_t
```
teradata: period(n)

pls_integer_t

public static final EDataType pls_integer_t

plsql pls_integer

point_t
```
public static final EDataType point_t
```

polygon_t

public static final EDataType polygon_t

raw_t
```
public static final EDataType raw_t
```

real_t
```
public static final EDataType real_t
```
ansi2003: real

rowid_t
```
public static final EDataType rowid_t
```

rowversion_t

public static final EDataType rowversion_t

serial_t
```
public static final EDataType serial_t
```

serial8_t

public static final EDataType serial8_t

bigserial_t

public static final EDataType bigserial_t

smallfloat_t

public static final EDataType smallfloat_t

set_t
```
public static final EDataType set_t
```
MySQL: set

smalldatetime_t

public static final EDataType smalldatetime_t

smallint_t

public static final EDataType smallint_t

ansi2003: smallint

smallmoney_t

public static final EDataType smallmoney_t

sql_variant_t

public static final EDataType sql_variant_t

table_t
```
public static final EDataType table_t
```

text_t
```
public static final EDataType text_t
```

time_t
```
public static final EDataType time_t
```
ansi2003: time

time_with_time_zone_t

public static final EDataType time_with_time_zone_t

teradata: time with time zone

time_without_time_zone_t

public static final EDataType time_without_time_zone_t

timespan_t

public static final EDataType timespan_t

timestamp_t

public static final EDataType timestamp_t

timestamp_with_local_time_zone_t
```
public static final EDataType timestamp_with_local_time_zone_t
```
timestamp with local time zone, Database: Oracle,SQL Server

timestamp_with_time_zone_t
```
public static final EDataType timestamp_with_time_zone_t
```
timestamp with time zone, timestamptz, ansi2003: timestamp with time zone

timestamp_without_time_zone_t

public static final EDataType timestamp_without_time_zone_t

timetz_t
```
public static final EDataType timetz_t
```
time with time zone, ansi2003: time with time zone Databases: teradata

timentz_t

public static final EDataType timentz_t

tinyblob_t

public static final EDataType tinyblob_t

tinyint_t

public static final EDataType tinyint_t

tinytext_t

public static final EDataType tinytext_t

uniqueidentifier_t

public static final EDataType uniqueidentifier_t

urowid_t
```
public static final EDataType urowid_t
```

varbinary_t

public static final EDataType varbinary_t

ansi2003: blob

varbit_t
```
public static final EDataType varbit_t
```
netezza, bit varying

varbyte_t

public static final EDataType varbyte_t

teradata: varbyte

varchar_t
```
public static final EDataType varchar_t
```
varchar, char varying, character varying, ansi2003:character varying(n)

varchar2_t

public static final EDataType varchar2_t

ansi2003: character varying

varchar_for_bit_data_t

public static final EDataType varchar_for_bit_data_t

lvarchar_t

public static final EDataType lvarchar_t

idssecuritylabel_t

public static final EDataType idssecuritylabel_t

vargraphic_t

public static final EDataType vargraphic_t

ansi2003: nchar varying

row_data_types_t

public static final EDataType row_data_types_t

collection_data_types_collection_t

public static final EDataType collection_data_types_collection_t

collection_data_types_set_t

public static final EDataType collection_data_types_set_t

collection_data_types_multiset_t

public static final EDataType collection_data_types_multiset_t

collection_data_types_list_t

public static final EDataType collection_data_types_list_t

no_typename_t
```
public static final EDataType no_typename_t
```
datatypeAttribute in cast function will be treated as a datatype without typename RW_CAST ( expr AS datatypeAttribute )

year_t
```
public static final EDataType year_t
```

xml_t
```
public static final EDataType xml_t
```

xmltype_t

public static final EDataType xmltype_t

natural_t

public static final EDataType natural_t

naturaln_t

public static final EDataType naturaln_t

positive_t

public static final EDataType positive_t

positiven_t

public static final EDataType positiven_t

signtype_t

public static final EDataType signtype_t

simple_integer_t

public static final EDataType simple_integer_t

double_precision_t

public static final EDataType double_precision_t

boolean_t

public static final EDataType boolean_t

string_t
```
public static final EDataType string_t
```

listType_t

public static final EDataType listType_t

structType_t
```
public static final EDataType structType_t
```
Deprecated. As of v2.3.4.6, please use struct_t instead

mapType_t

public static final EDataType mapType_t

unionType_t

public static final EDataType unionType_t

refcursor_t

public static final EDataType refcursor_t

json_t
```
public static final EDataType json_t
```

jsonb_t
```
public static final EDataType jsonb_t
```

self_t
```
public static final EDataType self_t
```

seconddate_t

public static final EDataType seconddate_t

smalldec_t

public static final EDataType smalldec_t

array_t
```
public static final EDataType array_t
```

varray_t
```
public static final EDataType varray_t
```

alphanum_t

public static final EDataType alphanum_t

shorttext_t

public static final EDataType shorttext_t

bintext_t

public static final EDataType bintext_t

currency_t

public static final EDataType currency_t

int8_t
```
public static final EDataType int8_t
```

lvarbinary_t

public static final EDataType lvarbinary_t

long_byte_t

public static final EDataType long_byte_t

object_t
```
public static final EDataType object_t
```

variant_t

public static final EDataType variant_t

unsigned_int_t

public static final EDataType unsigned_int_t

decfloat_t

public static final EDataType decfloat_t

struct_t
```
public static final EDataType struct_t
```

int64_t
```
public static final EDataType int64_t
```

float64_t

public static final EDataType float64_t

anyType_t

public static final EDataType anyType_t

map_t
```
public static final EDataType map_t
```

row_t
```
public static final EDataType row_t
```

resultset_t

public static final EDataType resultset_t

td_anytype_t

public static final EDataType td_anytype_t

char_byte_t

public static final EDataType char_byte_t

fixed_t
```
public static final EDataType fixed_t
```

st_geometry_t

public static final EDataType st_geometry_t

largeint_t

public static final EDataType largeint_t

hll_t
```
public static final EDataType hll_t
```

bitmap_t
```
public static final EDataType bitmap_t
```

quantile_state_t

public static final EDataType quantile_state_t

agg_state_t

public static final EDataType agg_state_t

ipv4_t
```
public static final EDataType ipv4_t
```

ipv6_t
```
public static final EDataType ipv6_t
```

vector_t
```
public static final EDataType vector_t
```

range_t
```
public static final EDataType range_t
```

Method Detail
- values
```
public static EDataType[] values()
```
  Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
```
for (EDataType c : EDataType.values())
    System.out.println(c);
```
  Returns:
  
  an array containing the constants of this enum type, in the order they are declared
- valueOf
```
public static EDataType 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

Enum EDataType

Enum Constant Summary

Method Summary

Methods inherited from class Enum

Methods inherited from class Object

Enum Constant Detail

unknown_t

generic_t

bfile_t

bigint_t

bignumeric_t

binary_t

binary_float_t

binary_double_t

binary_integer_t

binary_large_object_t

bit_t

bit_varying_t

blob_t

bool_t

box_t

byte_t

bytea_t

byteint_t

character_t

char_t

char_for_bit_data_t

char_large_object_t

cidr_t

circle_t

clob_t

cursor_t

datalink_t

date_t

datetime_t

datetimeoffset_t

datetime2_t

dbclob_t

decimal_t

dec_t

double_t

enum_t

float_t

float4_t

float8_t