Package gudusoft.gsqlparser

Enum ESqlClause

Object

Enum<ESqlClause>

gudusoft.gsqlparser.ESqlClause

All Implemented Interfaces:

Serializable, Comparable<ESqlClause>, java.lang.constant.Constable

public enum ESqlClause
extends Enum<ESqlClause>

Enum for various SQL clause such as where clause, having clause and etc.

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constants

Enum Constant	Description
cluster
columnAlias
compute
constraintRef
containsTable
createTable
cte
datachangeTable
distributeBy
elTable
expandOn	teradata expand on clause
forUpdate
groupby
having
hierarchical
index
insertColumn
insertValues	values clause of insert
join
joinCondition
jsonTable
limit
lockingClause	postgresql for update of,
mergeInsert
opendatasource
openquery
openrowset
openxml
orderby
outerTable
output	output clause in update statement
pivot_in
pivoted_table
qualify	teradata qualify clause
resultColumn	Deprecated. As of v1.8.8.9, use insertColumn, mergeInsert, selectList instead
returning	returning clause in update statement
rowList
sample	SQL Server sample clause
selectInto	into clause in select
selectList
selectValue	value clause in select
set	set clause in update
setValue
setVariable	set variable
sortby	hive sort by clause
spAssignValue
tableExpr
tableFunction
tableHint
tableIndexOption
tdUnPivot
teradataWith
top	sql server top clause
transformClause
unknown
unSet
valueClause
viewAlias	view alias in create view statement
where
windowClause
xmlElementName
xmltable

Method Summary

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

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

unknown

public static final ESqlClause unknown

resultColumn

public static final ESqlClause resultColumn

Deprecated.

As of v1.8.8.9, use insertColumn, mergeInsert, selectList instead

where

public static final ESqlClause where

having

public static final ESqlClause having

groupby

public static final ESqlClause groupby

orderby

public static final ESqlClause orderby

joinCondition

public static final ESqlClause joinCondition

join

public static final ESqlClause join

hierarchical

public static final ESqlClause hierarchical

compute

public static final ESqlClause compute

windowClause

public static final ESqlClause windowClause

top

public static final ESqlClause top

sql server top clause

set

public static final ESqlClause set

set clause in update

insertValues

public static final ESqlClause insertValues

values clause of insert

selectInto

public static final ESqlClause selectInto

into clause in select

qualify

public static final ESqlClause qualify

teradata qualify clause

sample

public static final ESqlClause sample

SQL Server sample clause

teradataWith

public static final ESqlClause teradataWith

expandOn

public static final ESqlClause expandOn

teradata expand on clause

limit

public static final ESqlClause limit

sortby

public static final ESqlClause sortby

hive sort by clause

selectValue

public static final ESqlClause selectValue

value clause in select

viewAlias

public static final ESqlClause viewAlias

view alias in create view statement

cte

public static final ESqlClause cte

forUpdate

public static final ESqlClause forUpdate

output

public static final ESqlClause output

output clause in update statement

returning

public static final ESqlClause returning

returning clause in update statement

setVariable

public static final ESqlClause setVariable

set variable

lockingClause

public static final ESqlClause lockingClause

postgresql for update of,

transformClause

public static final ESqlClause transformClause

distributeBy

public static final ESqlClause distributeBy

index

public static final ESqlClause index

tableHint

public static final ESqlClause tableHint

elTable

public static final ESqlClause elTable

createTable

public static final ESqlClause createTable

constraintRef

public static final ESqlClause constraintRef

insertColumn

public static final ESqlClause insertColumn

setValue

public static final ESqlClause setValue

columnAlias

public static final ESqlClause columnAlias

unSet

public static final ESqlClause unSet

tableFunction

public static final ESqlClause tableFunction

tableExpr

public static final ESqlClause tableExpr

containsTable

public static final ESqlClause containsTable

openrowset

public static final ESqlClause openrowset

openxml

public static final ESqlClause openxml

opendatasource

public static final ESqlClause opendatasource

openquery

public static final ESqlClause openquery

datachangeTable

public static final ESqlClause datachangeTable

rowList

public static final ESqlClause rowList

pivoted_table

public static final ESqlClause pivoted_table

xmltable

public static final ESqlClause xmltable

outerTable

public static final ESqlClause outerTable

mergeInsert

public static final ESqlClause mergeInsert

selectList

public static final ESqlClause selectList

spAssignValue

public static final ESqlClause spAssignValue

tdUnPivot

public static final ESqlClause tdUnPivot

xmlElementName

public static final ESqlClause xmlElementName

tableIndexOption

public static final ESqlClause tableIndexOption

jsonTable

public static final ESqlClause jsonTable

pivot_in

public static final ESqlClause pivot_in

cluster

public static final ESqlClause cluster

valueClause

public static final ESqlClause valueClause

Method Details

values

public static ESqlClause[] 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 ESqlClause 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