gudusoft.gsqlparser

Enum ESqlClause

java.lang.Object

java.lang.Enum<ESqlClause>

gudusoft.gsqlparser.ESqlClause

All Implemented Interfaces:

Serializable, Comparable<ESqlClause>

public enum ESqlClause
extends Enum<ESqlClause>

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

Enum Constant Summary

Enum Constants

Enum Constant and Description
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
limit
lockingClause postgresql for update of,
mergeInsert
opendatasource
openquery
openrowset
openxml
orderby
outerTable
output output clause in update statement
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
tdUnPivot
teradataWith
top sql server top clause
transformClause
unknown
unSet
viewAlias view alias in create view statement
where
windowClause
xmltable

Method Summary

Modifier and Type	Method and 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, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

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

Method Detail

values

public static ESqlClause[] 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 (ESqlClause c : ESqlClause.values())
    System.out.println(c);

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