|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectgudusoft.gsqlparser.nodes.TParseTreeNode
gudusoft.gsqlparser.nodes.TCTE
public class TCTE
A common table expression permits defining a result table with a table-name that can be specified as a table name in any FROM clause of the fullselect that follows.
Multiple common table expressions can be specified following the single WITH keyword.
Each common table expression specified can also be referenced by name in the FROM clause of subsequent common table expressions.
Syntax:
table-name [column-name [,...n]] AS (fullselect)
Constructor Summary | |
---|---|
TCTE()
|
Method Summary | |
---|---|
void |
accept(TParseTreeVisitor v)
|
void |
doParse(TCustomSqlStatement psql,
ESqlClause plocation)
analyze this node |
TObjectNameList |
getColumnList()
|
TDeleteSqlStatement |
getDeleteStmt()
|
TInsertSqlStatement |
getInsertStmt()
|
TCustomSqlStatement |
getPreparableStmt()
preparable statement can be: |
TSelectSqlStatement |
getSubquery()
fullselect of this common table expression. |
TObjectName |
getTableName()
|
TUpdateSqlStatement |
getUpdateStmt()
|
void |
init(java.lang.Object arg1,
java.lang.Object arg2)
|
void |
setColumnList(TObjectNameList columnList)
|
Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode |
---|
addAllMyTokensToTokenList, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, init, setDummyTag, setEndToken, setEndToken, setGsqlparser, setNodeType, setStartToken, setStartToken, setString, toString |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Constructor Detail |
---|
public TCTE()
Method Detail |
---|
public TCustomSqlStatement getPreparableStmt()
public TUpdateSqlStatement getUpdateStmt()
public TInsertSqlStatement getInsertStmt()
public TDeleteSqlStatement getDeleteStmt()
public TObjectName getTableName()
public void setColumnList(TObjectNameList columnList)
public TSelectSqlStatement getSubquery()
public TObjectNameList getColumnList()
public void init(java.lang.Object arg1, java.lang.Object arg2)
init
in class TParseTreeNode
public void doParse(TCustomSqlStatement psql, ESqlClause plocation)
TParseTreeNode
doParse
in class TParseTreeNode
public void accept(TParseTreeVisitor v)
accept
in interface Visitable
accept
in class TParseTreeNode
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |