Package smacs.sql.syntaxtree

JTB SqlTree.jtb Nodes

See:
Description

Interface Summary

Node	The interface which all syntax tree classes must implement.
NodeListInterface	The interface which NodeList, NodeListOptional, and NodeSequence implement.

Class Summary

DotObjectName	Grammar production: nodeChoice -> <S_IDENTIFIER> | <S_QUOTED_IDENTIFIER> | <S_CHAR_LITERAL> | <K_ADD> | <K_ALTER> | <K_ASC> | <K_BETWEEN> | <K_BINARY_INTEGER> | <K_BOOLEAN> | <K_CHAR> | <K_CLOSE> | <K_COMMENT> | <K_COMMIT> | <K_CONNECT> | <K_CONSTANT> | <K_CONSTRAINT> | <K_CREATE> | <K_CURRENT> | <K_CURSOR> | <K_DATE> | <K_DECIMAL> | <K_DECLARE> | <K_DELETE> | <K_DESC> | <K_DISTINCT> | <K_DROP> | <K_EXCEPTION> | <K_EXCEPTION_INIT> | <K_EXCLUSIVE> | <K_EXISTS> | <K_EXIT> | <K_FETCH> | <K_FLOAT> | <K_FUNCTION> | <K_GOTO> | <K_GROUP> | <K_HAVING> | <K_INDEX> | <K_INSERT> | <K_INTEGER> | <K_INTERSECT> | <K_INTO> | <K_JOIN> | <K_LEVEL> | <K_LIKE> | <K_LOOP> | <K_MINUS> | <K_MODE> | <K_NATURAL> | <K_NOWAIT> | <K_NUMBER> | <K_ONLY> | <K_OPEN> | <K_ORDER> | <K_OTHERS> | <K_PACKAGE> | <K_POSITIVE> | <K_PRAGMA> | <K_PRIOR> | <K_PROCEDURE> | <K_RAISE> | <K_READ> | <K_REAL> | <K_RECORD> | <K_REFERENCES> | <K_RETURN> | <K_RETURNS> | <K_REVERSE> | <K_ROLLBACK> | <K_RULE> | <K_SAVEPOINT> | <K_SCHEMA> | <K_SEGMENT> | <K_SELECT> | <K_SEQUENCE> | <K_SHARE> | <K_SMALLINT> | <K_START> | <K_TABLE> | <K_THEN> | <K_TRANSACTION> | <K_TRANSFORM> | <K_UNION> | <K_UPDATE> | <K_VALUES> | <K_VARCHAR2> | <K_VARCHAR> | <K_VIEW> | <K_WHERE> | <K_WORK> | <K_WRITE>
NodeChoice	Represents a grammar choice, e.g. ( A | B )
NodeList	Represents a grammar list, e.g. ( A )+
NodeListOptional	Represents an optional grammar list, e.g. ( A )*
NodeOptional	Represents an grammar optional node, e.g. ( A )?
NodeSequence	Represents a sequence of nodes nested within a choice, list, optional list, or optional, e.g. ( A B )+ or [ C D E ]
NodeToken	Represents a single token in the grammar.
PlSqlAdditiveExpression	Grammar production: plSqlMultiplicativeExpressions -> PlSqlMultiplicativeExpressions() nodeList -> ( SqlAdditiveHint() PlSqlMultiplicativeExpressions() )+
PlSqlAndExpression	Grammar production: plSqlUnaryLogicalExpressions -> PlSqlUnaryLogicalExpressions() nodeList -> ( "AND" PlSqlUnaryLogicalExpressions() )+
PlSqlAndExpressions	Grammar production: nodeChoice -> PlSqlAndExpression() | PlSqlUnaryLogicalExpressions()
PlSqlArguments	Grammar production: plSqlExpressionList -> PlSqlExpressionList()
PlSqlBetweenClause	Grammar production: nodeOptional -> [ "NOT" ] nodeToken -> "BETWEEN" plSqlSimpleExpressions -> PlSqlSimpleExpressions() nodeToken1 -> "AND" plSqlSimpleExpressions1 -> PlSqlSimpleExpressions()
PlSqlExpotentExpression	Grammar production: plSqlUnaryExpressions -> PlSqlUnaryExpressions() nodeList -> ( "**" PlSqlUnaryExpressions() )+
PlSqlExpotentExpressions	Grammar production: nodeChoice -> PlSqlExpotentExpression() | PlSqlUnaryExpressions()
PlSqlExpression	Grammar production: plSqlExpressions -> PlSqlExpressions()
PlSqlExpressionList	Grammar production: plSqlExpression -> PlSqlExpression() nodeListOptional -> ( "," PlSqlExpression() )*
PlSqlExpressions	Grammar production: nodeChoice -> PlSqlOrExpression() | PlSqlAndExpressions()
PlSqlInClause	Grammar production: nodeOptional -> [ "NOT" ] nodeToken -> "IN" nodeToken1 -> "(" plSqlExpressionList -> PlSqlExpressionList() nodeToken2 -> ")"
PlSqlLikeClause	Grammar production: nodeOptional -> [ "NOT" ] nodeToken -> "LIKE" plSqlSimpleExpressions -> PlSqlSimpleExpressions()
PlSqlMultiplicativeExpression	Grammar production: plSqlExpotentExpressions -> PlSqlExpotentExpressions() nodeList -> ( ( "*" | "/" ) PlSqlExpotentExpressions() )+
PlSqlMultiplicativeExpressions	Grammar production: nodeChoice -> PlSqlMultiplicativeExpression() | PlSqlExpotentExpressions()
PlSqlOrExpression	Grammar production: plSqlAndExpressions -> PlSqlAndExpressions() nodeList -> ( "OR" PlSqlAndExpressions() )+
PlSqlPrimaryExpression	Grammar production: nodeChoice -> SqlNullExpression() | ( RelObjectName() ( "%FOUND" | "%NOTFOUND" | "%ISOPEN" | "%ROWCOUNT" ) ) | ( RelObjectName() "(" PlSqlArguments() ")" ) | ( RelObjectName() [ "."
PlSqlRelationalExpression	Grammar production: plSqlSimpleExpressions -> PlSqlSimpleExpressions() nodeChoice -> ( SqlRelop() PlSqlSimpleExpressions() | PlSqlInClause() | PlSqlBetweenClause() | PlSqlLikeClause() | SqlIsNullClause() )
PlSqlRelationalExpressions	Grammar production: nodeChoice -> PlSqlRelationalExpression() | PlSqlSimpleExpressions()
PlSqlSimpleExpression	Grammar production: plSqlSimpleExpressions -> PlSqlSimpleExpressions()
PlSqlSimpleExpressions	Grammar production: nodeChoice -> PlSqlAdditiveExpression() | PlSqlMultiplicativeExpressions()
PlSqlStatement	Grammar production: nodeChoice -> SqlSubroutineCall() | SqlAssignmentStatement() | SqlExitStatement() | SqlGotoStatement() | SqlIfStatement() | SqlLoopStatement() | SqlNullStatement() | SqlRaiseStatement() | SqlReturnStatement() | SqlStatement() | SqlLabelDeclaration() | [ SqlDeclarationSection() ] SqlBeginEndBlock()
PlSqlUnaryExpression	Grammar production: nodeSequence -> ( ( "+" | "-" ) PlSqlPrimaryExpression() )
PlSqlUnaryExpressions	Grammar production: nodeChoice -> PlSqlUnaryExpression() | PlSqlPrimaryExpression()
PlSqlUnaryLogicalExpression	Grammar production: nodeToken -> "NOT" plSqlRelationalExpressions -> PlSqlRelationalExpressions()
PlSqlUnaryLogicalExpressions	Grammar production: nodeChoice -> PlSqlUnaryLogicalExpression() | PlSqlRelationalExpressions()
RelObjectName	Grammar production: nodeChoice -> <S_IDENTIFIER> | <S_QUOTED_IDENTIFIER> | <S_CHAR_LITERAL> | <K_COMMENT>
S_Char_Literal	Grammar production: nodeToken -> <S_CHAR_LITERAL>
S_Identifier	Grammar production: nodeToken -> <S_IDENTIFIER>
S_Quoted_Identifier	Grammar production: nodeToken -> <S_QUOTED_IDENTIFIER>
SqlAdditiveExpression	Grammar production: sqlMultiplicativeExpressions -> SqlMultiplicativeExpressions() nodeList -> ( SqlAdditiveHint() SqlMultiplicativeExpressions() )+
SqlAdditiveExpressions	Grammar production: nodeChoice -> SqlAdditiveExpression() | SqlMultiplicativeExpressions()
SqlAdditiveHint	Grammar production: nodeChoice -> "+" | "-" | "||"
SqlAllAnyHint	Grammar production: nodeChoice -> "ALL" | "ANY"
SqlAllDistinctHint	Grammar production: nodeChoice -> "ALL" | "DISTINCT"
SqlAlterStatement	Grammar production: nodeChoice -> SqlAlterTableStatement() | SqlAlterViewStatement()
SqlAlterTableStatement	Grammar production: nodeToken -> <K_ALTER> sqlChangeTableDeclaration -> SqlChangeTableDeclaration() nodeToken1 -> ";"
SqlAlterViewStatement	Grammar production: nodeToken -> <K_ALTER> sqlChangeViewDeclaration -> SqlChangeViewDeclaration() nodeToken1 -> ";"
SqlAndExpression	Grammar production: sqlUnaryLogicalExpressions -> SqlUnaryLogicalExpressions() nodeList -> ( "AND" SqlUnaryLogicalExpressions() )+
SqlAndExpressions	Grammar production: nodeChoice -> SqlAndExpression() | SqlUnaryLogicalExpressions()
SqlArguments	Grammar production: sqlExpressionList -> SqlExpressionList()
SqlAsObjectExpression	Grammar production: nodeToken -> "AS" nodeToken1 -> "(" sqlExpression -> SqlExpression() nodeToken2 -> ")"
SqlAsObjectName	Grammar production: nodeChoice -> "AS" DotObjectName() | RelObjectName()
SqlAsObjectNames	Grammar production: nodeChoice -> SqlAsObjectExpression() | SqlAsObjectName()
SqlAssignmentStatement	Grammar production: nodeChoice -> ( ( RelObjectName() [ "."
SqlBasicDataTypeDeclaration	Grammar production: nodeChoice -> ( "CHAR" | "VARCHAR" | "VARCHAR2" | "INTEGER" | "NUMBER" | "NATURAL" | "REAL" | "FLOAT" ) [ "(" <S_NUMBER> [ "," <S_NUMBER> ] ")" ] | "DATE" | "BINARY_INTEGER" | "BOOLEAN"
SqlBeginEndBlock	Grammar production: nodeToken -> "BEGIN" sqlSequenceOfStatements -> SqlSequenceOfStatements() nodeOptional -> [ SqlExceptionBlock() ] nodeToken1 -> "END" nodeOptional1 -> [ RelObjectName() ] nodeToken2 -> ";"
SqlBetweenClause	Grammar production: nodeOptional -> [ "NOT" ] nodeToken -> "BETWEEN" sqlSimpleExpression -> SqlSimpleExpression() nodeToken1 -> "AND" sqlSimpleExpression1 -> SqlSimpleExpression()
SqlChangeTableDeclaration	Grammar production: nodeToken -> "TABLE" dotObjectName -> DotObjectName() nodeToken1 -> "ADD" nodeOptional -> [ "CONSTRAINT" DotObjectName() ] sqlForeignKeyFieldDeclaration -> SqlForeignKeyFieldDeclaration() nodeOptional1 -> [ "ON" "DELETE" RelObjectName() ]
SqlChangeViewDeclaration	Grammar production: nodeToken -> "VIEW" sqlTableReference -> SqlTableReference() nodeToken1 -> "ADD" sqlForeignKeyFieldDeclaration -> SqlForeignKeyFieldDeclaration()
SqlCloseStatement	Grammar production: nodeToken -> "CLOSE" relObjectName -> RelObjectName() nodeToken1 -> ";"
SqlColumnValues	Grammar production: sqlTableColumn -> SqlTableColumn() nodeToken -> "=" sqlUpdatedValue -> SqlUpdatedValue() nodeListOptional -> ( "," SqlTableColumn() "=" SqlUpdatedValue() )*
SqlCommitStatement	Grammar production: nodeToken -> "COMMIT" nodeOptional -> [ "WORK" ] nodeOptional1 -> [ "COMMENT" S_Char_Literal() ] nodeToken1 -> ";"
SqlCompilationUnit	Grammar production: nodeChoice -> SqlProcedureDeclaration() | SqlFunctionDeclaration() | SqlSequenceOfStatements()
SqlConnectClause	Grammar production: nodeSequence -> ( [ "START" "WITH" SqlExpression() ] "CONNECT" "BY" SqlExpression() [ "START" "WITH" SqlExpression() ] )
SqlConstantDeclaration	Grammar production: nodeToken -> "CONSTANT" sqlTypeDeclaration -> SqlTypeDeclaration() nodeListOptional -> ( SqlInitDeclaration() )*
SqlCreateFunctionStatement	Grammar production: nodeToken -> <K_CREATE> sqlFunctionDeclaration -> SqlFunctionDeclaration() nodeToken1 -> ";"
SqlCreateIndexStatement	Grammar production: nodeToken -> <K_CREATE> sqlIndexDeclaration -> SqlIndexDeclaration() nodeToken1 -> ";"
SqlCreateOrReplaceFunctionStatement	Grammar production: nodeToken -> <K_CREATE> nodeToken1 -> "OR" dotObjectName -> DotObjectName() sqlFunctionDeclaration -> SqlFunctionDeclaration() nodeToken2 -> ";"
SqlCreateOrReplaceIndexStatement	Grammar production: nodeToken -> <K_CREATE> nodeToken1 -> "OR" dotObjectName -> DotObjectName() sqlIndexDeclaration -> SqlIndexDeclaration() nodeToken2 -> ";"
SqlCreateOrReplacePackageStatement	Grammar production: nodeToken -> "CREATE" nodeToken1 -> "OR" dotObjectName -> DotObjectName() sqlPackageDeclaration -> SqlPackageDeclaration() nodeToken2 -> ";"
SqlCreateOrReplaceRuleStatement	Grammar production: nodeToken -> <K_CREATE> nodeToken1 -> "OR" dotObjectName -> DotObjectName() sqlRuleDeclaration -> SqlRuleDeclaration() nodeToken2 -> ";"
SqlCreateOrReplaceSchemaMappingStatement	Grammar production: nodeToken -> "CREATE" nodeToken1 -> "OR" dotObjectName -> DotObjectName() sqlSchemaMappingDeclaration -> SqlSchemaMappingDeclaration() nodeToken2 -> ";"
SqlCreateOrReplaceSchemaStatement	Grammar production: nodeToken -> "CREATE" nodeToken1 -> "OR" dotObjectName -> DotObjectName() sqlSchemaDeclaration -> SqlSchemaDeclaration() nodeToken2 -> ";"
SqlCreateOrReplaceSequenceStatement	Grammar production: nodeToken -> <K_CREATE> nodeToken1 -> "OR" dotObjectName -> DotObjectName() sqlSequenceDeclaration -> SqlSequenceDeclaration() nodeToken2 -> ";"
SqlCreateOrReplaceStatement	Grammar production: nodeChoice -> SqlCreateOrReplaceFunctionStatement() | SqlCreateOrReplaceTableStatement() | SqlCreateOrReplaceViewStatement() | SqlCreateOrReplaceSequenceStatement() | SqlCreateOrReplaceIndexStatement() | SqlCreateOrReplacePackageStatement() | SqlCreateOrReplaceSchemaMappingStatement() | SqlCreateOrReplaceSchemaStatement() | SqlCreateOrReplaceRuleStatement()
SqlCreateOrReplaceTableStatement	Grammar production: nodeToken -> <K_CREATE> nodeToken1 -> "OR" dotObjectName -> DotObjectName() sqlTableDeclaration -> SqlTableDeclaration() nodeToken2 -> ";"
SqlCreateOrReplaceViewStatement	Grammar production: nodeToken -> <K_CREATE> nodeToken1 -> "OR" dotObjectName -> DotObjectName() sqlViewDeclaration -> SqlViewDeclaration() nodeToken2 -> ";"
SqlCreatePackageStatement	Grammar production: nodeToken -> "CREATE" sqlPackageDeclaration -> SqlPackageDeclaration() nodeToken1 -> ";"
SqlCreateRuleStatement	Grammar production: nodeToken -> <K_CREATE> sqlRuleDeclaration -> SqlRuleDeclaration() nodeToken1 -> ";"
SqlCreateSchemaMappingStatement	Grammar production: nodeToken -> "CREATE" sqlSchemaMappingDeclaration -> SqlSchemaMappingDeclaration() nodeToken1 -> ";"
SqlCreateSchemaStatement	Grammar production: nodeToken -> "CREATE" sqlSchemaDeclaration -> SqlSchemaDeclaration() nodeToken1 -> ";"
SqlCreateSequenceStatement	Grammar production: nodeToken -> <K_CREATE> sqlSequenceDeclaration -> SqlSequenceDeclaration() nodeToken1 -> ";"
SqlCreateStatement	Grammar production: nodeChoice -> SqlCreateFunctionStatement() | SqlCreateTableStatement() | SqlCreateViewStatement() | SqlCreateSequenceStatement() | SqlCreateIndexStatement() | SqlCreatePackageStatement() | SqlCreateSchemaMappingStatement() | SqlCreateSchemaStatement() | SqlCreateRuleStatement() | SqlCreateOrReplaceStatement()
SqlCreateTableStatement	Grammar production: nodeToken -> <K_CREATE> sqlTableDeclaration -> SqlTableDeclaration() nodeToken1 -> ";"
SqlCreateViewStatement	Grammar production: nodeToken -> <K_CREATE> sqlViewDeclaration -> SqlViewDeclaration() nodeToken1 -> ";"
SqlCursorDeclaration	Grammar production: nodeToken -> "CURSOR" relObjectName -> RelObjectName() nodeOptional -> [ "(" [ SqlParameterList() ] ")" ] nodeToken1 -> "IS" sqlSelectStatement -> SqlSelectStatement()
SqlCursorForLoop	Grammar production: nodeToken -> "FOR" relObjectName -> RelObjectName() nodeToken1 -> "IN" nodeChoice -> ( RelObjectName() [ "(" PlSqlArguments() ")" ] | "(" SqlSelectStatement() ")" ) sqlNormalLoop -> SqlNormalLoop()
SqlDataTypeFieldDeclaration	Grammar production: dotObjectName -> DotObjectName() dotObjectName1 -> DotObjectName() nodeOptional -> [ "(" PlSqlArguments() ")" ] nodeListOptional -> ( SqlInitDeclaration() | SqlPrimaryKeyDeclaration() )*
SqlDeclarations	Grammar production: nodeList -> ( ( SqlIdentifierDeclaration() | SqlCursorDeclaration() | SqlPragmaDeclaration() ) ";" )+ nodeListOptional -> ( SqlProcedureDeclaration() | SqlFunctionDeclaration() )*
SqlDeclarationSection	Grammar production: nodeToken -> "DECLARE" sqlDeclarations -> SqlDeclarations()
SqlDefaultDeclaration	Grammar production: nodeChoice -> ( ":=" | "DEFAULT" ) plSqlExpression -> PlSqlExpression()
SqlDeleteStatement	Grammar production: nodeToken -> "DELETE" nodeOptional -> [ "FROM" ] sqlTableReference -> SqlTableReference() nodeOptional1 -> [ RelObjectName() ] nodeOptional2 -> [ "WHERE" ( SqlExpression() | "CURRENT" "OF" RelObjectName() ) ] nodeToken1 -> ";"
SqlDropFunctionDeclaration	Grammar production: nodeToken -> <K_DROP> nodeToken1 -> "FUNCTION" relObjectName -> RelObjectName() nodeOptional -> [ "(" [ SqlFieldList() ] ")" ] nodeToken2 -> ";"
SqlDropRuleDeclaration	Grammar production: nodeToken -> <K_DROP> nodeToken1 -> "RULE" dotObjectName -> DotObjectName() nodeToken2 -> ";"
SqlDropStatement	Grammar production: nodeChoice -> SqlDropFunctionDeclaration() | SqlDropViewDeclaration() | SqlDropTableDeclaration() | SqlDropRuleDeclaration()
SqlDropTableDeclaration	Grammar production: nodeToken -> <K_DROP> nodeToken1 -> "TABLE" sqlTableReference -> SqlTableReference() nodeToken2 -> ";"
SqlDropViewDeclaration	Grammar production: nodeToken -> <K_DROP> nodeToken1 -> "VIEW" sqlTableReference -> SqlTableReference() nodeToken2 -> ";"
SqlExceptionBlock	Grammar production: nodeToken -> "EXCEPTION" nodeList -> ( SqlExceptionHandler() )+
SqlExceptionDeclaration	Grammar production: nodeToken -> "EXCEPTION"
SqlExceptionHandler	Grammar production: nodeToken -> "WHEN" nodeChoice -> ( RelObjectName() ( "OR" RelObjectName() )* | "OTHERS" ) nodeToken1 -> "THEN" sqlSequenceOfStatements -> SqlSequenceOfStatements()
SqlExistsClause	Grammar production: nodeOptional -> [ "NOT" ] nodeToken -> "EXISTS" nodeToken1 -> "(" sqlSubQuery -> SqlSubQuery() nodeToken2 -> ")"
SqlExistsIntoClause	Grammar production: nodeToken -> "EXISTS" nodeOptional -> [ SqlAllDistinctHint() ] nodeChoice -> ( "INTO" | "FROM" ) sqlIntoTable -> SqlIntoTable() nodeOptional1 -> [ SqlSelectWhereClause() | SqlWhereClause() ] nodeOptional2 -> [ SqlWithOptions() ]
SqlExistsNewIntoClause	Grammar production: nodeToken -> "EXISTS" nodeOptional -> [ SqlAllDistinctHint() ] sqlOldNewHint -> SqlOldNewHint() nodeChoice -> ( "INTO" | "FROM" ) sqlIntoTable -> SqlIntoTable() nodeOptional1 -> [ SqlSelectWhereClause() | SqlWhereClause() ] nodeOptional2 -> [ SqlWithOptions() ]
SqlExitStatement	Grammar production: nodeToken -> "EXIT" nodeOptional -> [ RelObjectName() ] nodeOptional1 -> [ "WHEN" PlSqlExpression() ] nodeToken1 -> ";"
SqlExpotentExpression	Grammar production: sqlUnaryExpressions -> SqlUnaryExpressions() nodeList -> ( "**" SqlUnaryExpressions() )+
SqlExpotentExpressions	Grammar production: nodeChoice -> SqlExpotentExpression() | SqlUnaryExpressions()
SqlExpression	Grammar production: sqlOrExpressions -> SqlOrExpressions()
SqlExpressionList	Grammar production: sqlSimpleExpression -> SqlSimpleExpression() nodeListOptional -> ( "," SqlSimpleExpression() )*
SqlFetchStatement	Grammar production: nodeToken -> "FETCH" nodeSequence -> ( RelObjectName() ) nodeToken1 -> "INTO" nodeChoice -> ( RelObjectName() | <S_BIND> ) nodeListOptional -> ( "," ( RelObjectName() | <S_BIND> ) )* nodeToken2 -> ";"
SqlFieldDeclaration	Grammar production: nodeChoice -> SqlUniqueKeyFieldDeclaration() | SqlForeignKeyFieldDeclaration() | SqlPrimaryKeyFieldDeclaration() | SqlDataTypeFieldDeclaration()
SqlFieldDeclarationList	Grammar production: sqlFieldDeclaration -> SqlFieldDeclaration() nodeListOptional -> ( "," SqlFieldDeclaration() )*
SqlFieldList	Grammar production: dotObjectName -> DotObjectName() nodeListOptional -> ( "," DotObjectName() )*
SqlForeignKeyFieldDeclaration	Grammar production: relObjectName -> RelObjectName() nodeToken -> "KEY" nodeToken1 -> "(" sqlFieldList -> SqlFieldList() nodeToken2 -> ")" nodeToken3 -> "REFERENCES" sqlTableReference -> SqlTableReference() nodeToken4 -> "(" sqlFieldList1 -> SqlFieldList() nodeToken5 -> ")"
SqlForLoop	Grammar production: nodeChoice -> SqlNumericForLoop() | SqlCursorForLoop()
SqlForUpdateClause	Grammar production: nodeToken -> "FOR" nodeToken1 -> "UPDATE" nodeToken2 -> "OF" sqlTableColumn -> SqlTableColumn() nodeListOptional -> ( "," SqlTableColumn() )*
SqlFromClause	Grammar production: nodeToken -> "FROM" sqlFromItem -> SqlFromItem() nodeListOptional -> ( "," SqlFromItem() )*
SqlFromItem	Grammar production: nodeChoice -> ( SqlTableReference() | "(" SqlFromItemExpression() ")" | SqlTableExpression() ) nodeChoice1 -> ( SqlJoinerExpression() [ "AS" SqlAsObjectName() ] | [ SqlAsObjectName() ] )
SqlFromItemExpression	Grammar production: nodeChoice -> ( SqlTableReference() | "(" SqlFromItemExpression() ")" | SqlTableExpression() ) nodeListOptional -> ( SqlJoinerExpression() )*
SqlFunctionBody	Grammar production: nodeOptional -> [ SqlDeclarations() ] sqlBeginEndBlock -> SqlBeginEndBlock()
SqlFunctionCall	Grammar production: relObjectName -> RelObjectName() nodeOptional -> [ "."
SqlFunctionDeclaration	Grammar production: nodeToken -> "FUNCTION" relObjectName -> RelObjectName() nodeOptional -> [ "(" [ SqlParameterList() ] ")" ] nodeChoice -> ( "RETURN" | "RETURNS" ) sqlTypeDeclaration -> SqlTypeDeclaration() nodeChoice1 -> ( ";" | "IS" SqlFunctionBody() | "AS" S_Char_Literal() DotObjectName() ( RelObjectName() | "SQL" ) ( RelObjectName() )* )
SqlGotoStatement	Grammar production: nodeToken -> "GOTO" relObjectName -> RelObjectName() nodeToken1 -> ";"
SqlGroupByClause	Grammar production: nodeToken -> "GROUP" nodeToken1 -> "BY" sqlExpressionList -> SqlExpressionList() nodeOptional -> [ "HAVING" SqlExpression() ]
SqlIdentifierDeclaration	Grammar production: relObjectName -> RelObjectName() nodeChoice -> ( SqlConstantDeclaration() | SqlVariableDeclaration() | SqlExceptionDeclaration() )
SqlIfStatement	Grammar production: nodeToken -> "IF" plSqlExpression -> PlSqlExpression() nodeToken1 -> "THEN" sqlSequenceOfStatements -> SqlSequenceOfStatements() nodeListOptional -> ( "ELSIF" PlSqlExpression() "THEN" SqlSequenceOfStatements() )* nodeOptional -> [ "ELSE" SqlSequenceOfStatements() ] nodeToken2 -> "END" nodeToken3 -> "IF" nodeOptional1 -> [ RelObjectName() ] nodeToken4 -> ";"
SqlImportFromMapping	Grammar production: nodeToken -> "SEQUENCE" dotObjectName -> DotObjectName()
SqlImportFromSqlFile	Grammar production: nodeToken -> "SQL" dotObjectName -> DotObjectName()
SqlImportSchemaMappingStatement	Grammar production: nodeToken -> "FROM" nodeChoice -> ( SqlImportFromSqlFile() | SqlImportFromMapping() ) sqlImportSelect -> SqlImportSelect()
SqlImportSelect	Grammar production: nodeChoice -> SqlImportSelectSchemaSet() | SqlImportSelectInsertSet() | SqlImportSelectUpdateSet()
SqlImportSelectInsertSet	Grammar production: nodeToken -> "SELECT" nodeToken1 -> "INSERT" nodeToken2 -> "SEQUENCE" nodeOptional -> [ SqlImportSelectRenameSet() ]
SqlImportSelectRename	Grammar production: nodeChoice -> SqlImportSelectRenameSchemaList() | SqlImportSelectRenameTableList()
SqlImportSelectRenameSchema	Grammar production: relObjectName -> RelObjectName() sqlAsObjectName -> SqlAsObjectName()
SqlImportSelectRenameSchemaList	Grammar production: nodeToken -> "SCHEMA" sqlImportSelectRenameSchema -> SqlImportSelectRenameSchema() nodeListOptional -> ( "," SqlImportSelectRenameSchema() )*
SqlImportSelectRenameSet	Grammar production: nodeToken -> "WITH" sqlImportSelectRename -> SqlImportSelectRename() nodeListOptional -> ( "AND" SqlImportSelectRename() )*
SqlImportSelectRenameTable	Grammar production: sqlTableReference -> SqlTableReference() sqlAsObjectName -> SqlAsObjectName()
SqlImportSelectRenameTableList	Grammar production: nodeToken -> "TABLE" sqlImportSelectRenameSchema -> SqlImportSelectRenameSchema() nodeListOptional -> ( "," SqlImportSelectRenameSchema() )*
SqlImportSelectSchema	Grammar production: relObjectName -> RelObjectName() nodeOptional -> [ SqlAsObjectName() ]
SqlImportSelectSchemaSet	Grammar production: nodeToken -> "SELECT" nodeToken1 -> "SCHEMA" sqlImportSelectSchema -> SqlImportSelectSchema() nodeListOptional -> ( "," SqlImportSelectSchema() )* nodeOptional -> [ SqlImportSelectRenameSet() ]
SqlImportSelectUpdate	Grammar production: relObjectName -> RelObjectName() nodeOptional -> [ SqlAsObjectName() ]
SqlImportSelectUpdateSet	Grammar production: nodeToken -> "SELECT" nodeToken1 -> "UPDATE" nodeToken2 -> "SEQUENCE" sqlImportSelectUpdate -> SqlImportSelectUpdate() nodeListOptional -> ( "," SqlImportSelectUpdate() )* nodeOptional -> [ SqlImportSelectRenameSet() ]
SqlInClause	Grammar production: nodeOptional -> [ "NOT" ] nodeToken -> "IN" nodeToken1 -> "(" nodeChoice -> ( SqlExpressionList() | SqlSubQuery() ) nodeToken2 -> ")"
SqlIndexDeclaration	Grammar production: nodeOptional -> ( SqlUniqueType() )?
SqlInitDeclaration	Grammar production: nodeChoice -> SqlNotNullDeclaration() | SqlDefaultDeclaration()
SqlInsertFromStatement	Grammar production: nodeToken -> "INSERT" sqlFromClause -> SqlFromClause() nodeOptional -> [ SqlSelectWhereClause() | SqlWhereClause() ] nodeOptional1 -> [ SqlWithOptions() ] nodeListOptional -> ( ( SqlUpsertIntoClause() | SqlUpsertNewIntoClause() ) | ( SqlInsertIntoClause() | SqlInsertNewIntoClause() ) | ( SqlUpdateIntoClause() | SqlUpdateNewIntoClause() ) | ( SqlExistsIntoClause() | SqlExistsNewIntoClause() ) )* nodeToken1 -> ";"
SqlInsertIntoClause	Grammar production: nodeToken -> "INSERT" nodeOptional -> [ SqlAllDistinctHint() ] sqlIntoTableClause -> SqlIntoTableClause() nodeOptional1 -> [ SqlSelectWhereClause() | SqlWhereClause() ] nodeOptional2 -> [ SqlWithOptions() ]
SqlInsertIntoStatement	Grammar production: nodeToken -> "INSERT" sqlIntoTableClause -> SqlIntoTableClause() nodeChoice -> ( "VALUES" "(" PlSqlExpressionList() ")" | SqlSelectStatement() ) nodeToken1 -> ";"
SqlInsertNewFromStatement	Grammar production: nodeToken -> "INSERT" sqlOldNewHint -> SqlOldNewHint() sqlFromClause -> SqlFromClause() nodeOptional -> [ SqlSelectWhereClause() | SqlWhereClause() ] nodeOptional1 -> [ SqlWithOptions() ] nodeListOptional -> ( ( SqlUpsertIntoClause() | SqlUpsertNewIntoClause() ) | ( SqlInsertIntoClause() | SqlInsertNewIntoClause() ) | ( SqlUpdateIntoClause() | SqlUpdateNewIntoClause() ) | ( SqlExistsIntoClause() | SqlExistsNewIntoClause() ) )* nodeToken1 -> ";"
SqlInsertNewIntoClause	Grammar production: nodeToken -> "INSERT" nodeOptional -> [ SqlAllDistinctHint() ] sqlOldNewHint -> SqlOldNewHint() sqlIntoTableClause -> SqlIntoTableClause() nodeOptional1 -> [ SqlSelectWhereClause() | SqlWhereClause() ] nodeOptional2 -> [ SqlWithOptions() ]
SqlInsertNewIntoStatement	Grammar production: nodeToken -> "INSERT" sqlOldNewHint -> SqlOldNewHint() sqlIntoTableClause -> SqlIntoTableClause() nodeChoice -> ( "VALUES" "(" PlSqlExpressionList() ")" | SqlSelectStatement() ) nodeToken1 -> ";"
SqlInsertStatement	Grammar production: nodeChoice -> SqlInsertIntoStatement() | SqlInsertFromStatement() | SqlInsertNewIntoStatement() | SqlInsertNewFromStatement() | SqlInsertTransformStatement() | SqlInsertTransformStatement()
SqlInsertTransformStatement	Grammar production: nodeChoice -> ( "TRANSFORM" | "INSERT" "FOR" ) nodeOptional -> [ SqlOldNewHint() ] sqlSelectStatement -> SqlSelectStatement() nodeOptional1 -> [ SqlWithOptions() ] nodeListOptional -> ( ( SqlUpsertIntoClause() | SqlUpsertNewIntoClause() ) | ( SqlInsertIntoClause() | SqlInsertNewIntoClause() ) | ( SqlUpdateIntoClause() | SqlUpdateNewIntoClause() ) | ( SqlExistsIntoClause() | SqlExistsNewIntoClause() ) )* nodeToken -> ";"
SqlIntoClause	Grammar production: nodeToken -> "INTO" sqlIntoItem -> SqlIntoItem() nodeListOptional -> ( "," SqlIntoItem() )*
SqlIntoItem	Grammar production: nodeChoice -> SqlTableReference() SqlTableReference() | ( <S_BIND> ) | SqlTableExpression()
SqlIntoTable	Grammar production: nodeChoice -> ( SqlTableReference() | SqlTableExpression() ) nodeOptional -> [ "(" SqlTableColumn() ( "," SqlTableColumn() )* ")" ] nodeOptional1 -> [ SqlAsObjectName() ]
SqlIntoTableClause	Grammar production: nodeToken -> "INTO" sqlIntoTable -> SqlIntoTable() nodeOptional -> [ SqlJoinWhereClause() ]
SqlIsNullClause	Grammar production: nodeToken -> "IS" nodeChoice -> ( SqlNullExpression() | SqlNotNullExpression() )
SqlJoinerExpression	Grammar production: nodeChoice -> "JOIN" ( SqlTableReference() | SqlTableExpression() ) [ SqlJoinWhereClause() ] | RelObjectName() "JOIN" ( SqlTableReference() | SqlTableExpression() ) [ SqlJoinWhereClause() ]
SqlJoinWhereClause	Grammar production: nodeToken -> "ON" sqlExpression -> SqlExpression()
SqlLabelDeclaration	Grammar production: nodeToken -> "<<" relObjectName -> RelObjectName() nodeToken1 -> ">>"
SqlLikeClause	Grammar production: nodeOptional -> [ "NOT" ] nodeToken -> "LIKE" sqlSimpleExpression -> SqlSimpleExpression()
SqlLockMode	Grammar production: nodeChoice -> ( "ROW" ( "SHARE" | "EXCLUSIVE" ) ) | ( "SHARE" [ "UPDATE" | ( "ROW" "EXCLUSIVE" ) ] ) | ( "EXCLUSIVE" )
SqlLockTableStatement	Grammar production: nodeToken -> "LOCK" nodeToken1 -> "TABLE" sqlTableReference -> SqlTableReference() nodeListOptional -> ( "," SqlTableReference() )* nodeToken2 -> "IN" sqlLockMode -> SqlLockMode() nodeToken3 -> "MODE" nodeOptional -> [ "NOWAIT" ] nodeToken4 -> ";"
SqlLoopStatement	Grammar production: nodeChoice -> SqlNormalLoop() | SqlWhileLoop() | SqlForLoop()
SqlMaterializedCursor	Grammar production: dotObjectName -> DotObjectName() nodeToken -> "CURSOR"
SqlMetaData	Grammar production: nodeToken -> "<" relObjectName -> RelObjectName() nodeToken1 -> ">"
SqlMultiplicativeExpression	Grammar production: sqlExpotentExpressions -> SqlExpotentExpressions() nodeList -> ( ( "*" | "/" ) SqlExpotentExpressions() )+
SqlMultiplicativeExpressions	Grammar production: nodeChoice -> SqlMultiplicativeExpression() | SqlExpotentExpressions()
SqlNormalLoop	Grammar production: nodeToken -> "LOOP" sqlSequenceOfStatements -> SqlSequenceOfStatements() nodeToken1 -> "END" nodeToken2 -> "LOOP" nodeOptional -> [ RelObjectName() ] nodeToken3 -> ";"
SqlNotNullDeclaration	Grammar production: nodeToken -> "NOT" nodeToken1 -> "NULL"
SqlNotNullExpression	Grammar production: nodeToken -> "NOT" nodeToken1 -> "NULL"
SqlNullExpression	Grammar production: nodeToken -> "NULL"
SqlNullStatement	Grammar production: sqlNullExpression -> SqlNullExpression() nodeToken -> ";"
SqlNumericForLoop	Grammar production: nodeToken -> "FOR" relObjectName -> RelObjectName() nodeToken1 -> "IN" nodeOptional -> [ "REVERSE" ] plSqlSimpleExpression -> PlSqlSimpleExpression() nodeToken2 -> ".."
SqlNumericForLoopLookahead	Grammar production: nodeToken -> "FOR" relObjectName -> RelObjectName() nodeToken1 -> "IN" nodeOptional -> [ "REVERSE" ] plSqlSimpleExpression -> PlSqlSimpleExpression() nodeToken2 -> ".."
SqlNumOrID	Grammar production: nodeChoice -> <S_IDENTIFIER> | ( [ "+" | "-" ] <S_NUMBER> )
SqlOldNewHint	Grammar production: relObjectName -> RelObjectName()
SqlOpenStatement	Grammar production: nodeToken -> "OPEN" relObjectName -> RelObjectName() nodeOptional -> [ "(" PlSqlArguments() ")" ] nodeToken1 -> ";"
SqlOracleObjectName	Grammar production: nodeChoice -> <S_IDENTIFIER> | <S_QUOTED_IDENTIFIER>
SqlOrderByClause	Grammar production: nodeToken -> "ORDER" nodeToken1 -> "BY" sqlSimpleExpression -> SqlSimpleExpression() nodeOptional -> [ "ASC" | "DESC" ] nodeListOptional -> ( "," SqlSimpleExpression() [ "ASC" | "DESC" ] )*
SqlOrExpression	Grammar production: sqlAndExpressions -> SqlAndExpressions() nodeList -> ( "OR" SqlAndExpressions() )+
SqlOrExpressions	Grammar production: nodeChoice -> SqlOrExpression() | SqlAndExpressions()
SqlOuterJoinExpression	Grammar production: relObjectName -> RelObjectName() nodeOptional -> [ "."
SqlPackageDeclaration	Grammar production: nodeToken -> "PACKAGE" dotObjectName -> DotObjectName() nodeToken1 -> "IS" sqlPackageDeclarationList -> SqlPackageDeclarationList() nodeToken2 -> "END"
SqlPackageDeclarationList	Grammar production: nodeChoice -> SqlTableDeclaration() | SqlFunctionDeclaration() | SqlSequenceDeclaration()
SqlParameter	Grammar production: relObjectName -> RelObjectName() nodeOptional -> [ [ "IN" ] [ "OUT" ] SqlTypeDeclaration() [ ( ":=" | "DEFAULT" ) PlSqlExpression() ] ]
SqlParameterList	Grammar production: sqlParameter -> SqlParameter() nodeListOptional -> ( "," SqlParameter() )*
SqlPragmaDeclaration	Grammar production: nodeToken -> "PRAGMA" nodeToken1 -> "EXCEPTION_INIT" nodeToken2 -> "(" sqlNumOrID -> SqlNumOrID() nodeToken3 -> "," sqlNumOrID1 -> SqlNumOrID() nodeToken4 -> ")"
SqlPrimaryExpression	Grammar production: nodeChoice -> SqlNullExpression() | SqlFunctionCall() | SqlOuterJoinExpression() | SqlTableColumn() | <S_NUMBER> | <S_BIND> | "(" SqlExpression() ")"
SqlPrimaryKeyDeclaration	Grammar production: relObjectName -> RelObjectName() nodeToken -> "KEY"
SqlPrimaryKeyFieldDeclaration	Grammar production: relObjectName -> RelObjectName() nodeToken -> "KEY" nodeToken1 -> "(" sqlFieldList -> SqlFieldList() nodeToken2 -> ")"
SqlPriorExpression	Grammar production: nodeOptional -> [ "NOT" ] nodeToken -> "PRIOR" sqlSimpleExpressions -> SqlSimpleExpressions()
SqlProcedureBody	Grammar production: nodeOptional -> [ SqlDeclarations() ] sqlBeginEndBlock -> SqlBeginEndBlock()
SqlProcedureDeclaration	Grammar production: nodeToken -> "PROCEDURE" relObjectName -> RelObjectName() nodeOptional -> [ "(" [ SqlParameterList() ] ")" ] nodeChoice -> ( ";" | "IS" SqlProcedureBody() )
SqlQueryStatement	Grammar production: sqlSelectStatement -> SqlSelectStatement() nodeToken -> ";"
SqlRaiseStatement	Grammar production: nodeToken -> "RAISE" nodeOptional -> [ RelObjectName() ] nodeToken1 -> ";"
SqlRelationalExpression	Grammar production: nodeChoice -> ( "(" SqlExpressionList() ")" | SqlPriorExpression() | SqlSimpleExpressions() | "(" SqlSelectWithoutOrder() ")" ) nodeChoice1 -> ( ( SqlInClause() ) | ( SqlBetweenClause() ) | ( SqlLikeClause() ) | SqlIsNullClause() )
SqlRelationalExpressions	Grammar production: nodeChoice -> SqlRelationalExpression() | ( SqlRelopExpression() | "(" SqlExpressionList() ")" | ( SqlPriorExpression() | SqlSimpleExpressions() ) )
SqlRelationalOperatorExpression	Grammar production: sqlRelop -> SqlRelop() nodeChoice -> ( ( [ SqlAllAnyHint() ] "(" SqlSubQuery() ")" ) | SqlPriorExpression() | SqlSimpleExpression() )
SqlRelop	Grammar production: nodeChoice -> "=" | "!
SqlRelopExpression	Grammar production: nodeChoice -> ( "(" SqlExpressionList() ")" | ( SqlPriorExpression() | SqlSimpleExpressions() ) ) sqlRelop -> SqlRelop() nodeChoice1 -> ( ( [ SqlAllAnyHint() ] "(" SqlSubQuery() ")" ) | SqlPriorExpression() | SqlSimpleExpressions() )
SqlReturnStatement	Grammar production: nodeToken -> "RETURN" nodeOptional -> [ PlSqlExpression() ] nodeToken1 -> ";"
SqlRollbackStatement	Grammar production: nodeToken -> "ROLLBACK" nodeOptional -> [ "WORK" ] nodeOptional1 -> [ "TO" [ "SAVEPOINT" ] RelObjectName() ] nodeOptional2 -> [ "COMMENT" S_Char_Literal() ] nodeToken1 -> ";"
SqlRuleDeclaration	Grammar production: nodeToken -> "RULE" dotObjectName -> DotObjectName() nodeToken1 -> "AS" nodeToken2 -> "ON" dotObjectName1 -> DotObjectName() nodeOptional -> [ "TO" SqlTableReference() ] nodeOptional1 -> [ SqlWhereClause() ] nodeToken3 -> "DO" relObjectName -> RelObjectName() nodeChoice -> ( RelObjectName() | SqlInsertStatement() )
SqlSavepointStatement	Grammar production: nodeToken -> "SAVEPOINT" relObjectName -> RelObjectName() nodeToken1 -> ";"
SqlSchemaDeclaration	Grammar production: nodeToken -> "SCHEMA" dotObjectName -> DotObjectName() nodeListOptional -> ( SqlSchemaElement() )*
SqlSchemaElement	Grammar production: nodeChoice -> "CREATE" SqlTableDeclaration() | "CREATE" SqlViewDeclaration() | "CREATE" SqlIndexDeclaration() | "CREATE" SqlSequenceDeclaration()
SqlSchemaMappingDeclaration	Grammar production: nodeToken -> "UPDATE" nodeToken1 -> "SEQUENCE" dotObjectName -> DotObjectName() nodeChoice -> ( SqlSchemaMappingElement() | "BEGIN" ( SqlSchemaMappingElement() ";" )* "END" )
SqlSchemaMappingElement	Grammar production: nodeChoice -> SqlCreateSchemaStatement() | SqlCreateTableStatement() | SqlInsertStatement() | SqlImportSchemaMappingStatement()
SQLScript	Grammar production: nodeList -> ( SqlScriptStatements() )+
SqlScriptStatements	Grammar production: nodeChoice -> SqlStatement() | SqlFunctionDeclaration()
SqlSelectAll	Grammar production: nodeToken -> "*"
SqlSelectAllItems	Grammar production: nodeChoice -> RelObjectName() "." "*" | RelObjectName() "."
SqlSelectCurrentWithoutOrder	Grammar production: nodeToken -> "CURRENT" sqlSelectList -> SqlSelectList() nodeOptional -> [ SqlFromClause() ] nodeOptional1 -> [ SqlWhereClause() ] nodeOptional2 -> [ SqlConnectClause() ] nodeOptional3 -> [ SqlGroupByClause() ] nodeOptional4 -> [ SqlSetClause() ]
SqlSelectItem	Grammar production: nodeChoice -> SqlSelectAll() | SqlFunctionCall() [ SqlAsObjectNames() ] | SqlSelectAllItems() | SqlTableColumn() [ SqlAsObjectNames() ] | SqlMetaData() [ SqlAsObjectNames() ] | SqlNullExpression() [ SqlAsObjectNames() ] | "(" SqlSimpleExpression() ")" [ SqlAsObjectNames() ]
SqlSelectList	Grammar production: sqlSelectItem -> SqlSelectItem() nodeListOptional -> ( "," SqlSelectItem() )*
SqlSelectStatement	Grammar production: sqlSelectWithoutOrder -> SqlSelectWithoutOrder() nodeOptional -> [ SqlOrderByClause() ] nodeOptional1 -> [ SqlForUpdateClause() ]
SqlSelectWhereClause	Grammar production: nodeToken -> "SELECT" nodeOptional -> [ SqlAllDistinctHint() ] sqlSelectList -> SqlSelectList() nodeOptional1 -> [ SqlWhereClause() ] nodeOptional2 -> [ SqlConnectClause() ] nodeOptional3 -> [ SqlGroupByClause() ] nodeOptional4 -> [ SqlSetClause() ]
SqlSelectWithoutOrder	Grammar production: nodeToken -> "SELECT" nodeOptional -> [ SqlAllDistinctHint() ] sqlSelectList -> SqlSelectList() nodeOptional1 -> [ SqlIntoClause() ] sqlFromClause -> SqlFromClause() nodeOptional2 -> [ SqlWhereClause() ] nodeOptional3 -> [ SqlConnectClause() ] nodeOptional4 -> [ SqlGroupByClause() ] nodeOptional5 -> [ SqlSetClause() ]
SqlSequenceDeclaration	Grammar production: nodeOptional -> ( SqlSequenceType() )?
SqlSequenceOfStatements	Grammar production: nodeList -> ( PlSqlStatement() )+
SqlSequenceType	Grammar production: relObjectName -> RelObjectName()
SqlSetClause	Grammar production: nodeChoice -> ( ( "UNION" [ SqlAllDistinctHint() ] ) | "INTERSECT" | "MINUS" ) nodeChoice1 -> ( ( "(" SqlSelectWithoutOrder() ")" ) | SqlSelectWithoutOrder() )
SqlSetStatement	Grammar production: nodeChoice -> SqlSetTransactionStatement() | SqlSetVariableStatement()
SqlSetTransactionStatement	Grammar production: nodeToken -> "SET" nodeToken1 -> "TRANSACTION" nodeChoice -> ( ( "READ" ( "ONLY" | "WRITE" ) ) | ( "USE" "ROLLBACK" "SEGMENT" RelObjectName() ) ) nodeToken2 -> ";"
SqlSetVariableStatement	Grammar production: nodeToken -> "SET" relObjectName -> RelObjectName() nodeToken1 -> "TO" plSqlArguments -> PlSqlArguments() nodeToken2 -> ";"
SqlSimpleExpression	Grammar production: sqlSimpleExpressions -> SqlSimpleExpressions()
SqlSimpleExpressions	Grammar production: sqlAdditiveExpressions -> SqlAdditiveExpressions()
SqlStatement	Grammar production: nodeChoice -> SqlCloseStatement() | SqlCommitStatement() | SqlDeleteStatement() | SqlFetchStatement() | SqlInsertStatement() | SqlLockTableStatement() | SqlOpenStatement() | SqlRollbackStatement() | SqlSavepointStatement() | SqlQueryStatement() | SqlSetStatement() | SqlUpdateStatement() | SqlCreateStatement() | SqlDropStatement() | SqlAlterStatement()
SqlSubQuery	Grammar production: sqlSelectWithoutOrder -> SqlSelectWithoutOrder() sqlSelectCurrentWithoutOrder -> SqlSelectCurrentWithoutOrder()
SqlSubroutineCall	Grammar production: relObjectName -> RelObjectName() nodeOptional -> [ "."
SqlTableColumn	Grammar production: relObjectName -> RelObjectName() nodeOptional -> [ "."
SqlTableDeclaration	Grammar production: nodeToken -> "TABLE" sqlTableReference -> SqlTableReference() nodeToken1 -> "(" sqlFieldDeclarationList -> SqlFieldDeclarationList() nodeToken2 -> ")"
SqlTableExpression	Grammar production: nodeToken -> "TABLE" nodeToken1 -> "(" sqlExpression -> SqlExpression() nodeToken2 -> ")"
SqlTableReference	Grammar production: relObjectName -> RelObjectName() nodeOptional -> [ "."
SqlTypeDeclaration	Grammar production: nodeChoice -> SqlBasicDataTypeDeclaration() | ( RelObjectName() ( "%TYPE" | "%ROWTYPE" ) ) | SqlTableColumn() "%TYPE" | RelObjectName()
SqlUnaryExpression	Grammar production: nodeChoice -> ( "+" | "-" ) sqlPrimaryExpression -> SqlPrimaryExpression()
SqlUnaryExpressions	Grammar production: nodeChoice -> SqlUnaryExpression() | SqlPrimaryExpression()
SqlUnaryLogicalExpressions	Grammar production: nodeChoice -> SqlExistsClause() | SqlRelationalExpressions()
SqlUniqueKeyFieldDeclaration	Grammar production: nodeOptional -> [ <K_CONSTRAINT> DotObjectName() ] sqlUniqueType -> SqlUniqueType() nodeToken -> "(" sqlFieldList -> SqlFieldList() nodeToken1 -> ")"
SqlUniqueType	Grammar production: nodeToken -> <K_UNIQUE>
SqlUpdatedValue	Grammar production: nodeChoice -> "(" SqlSelectStatement() ")" | PlSqlExpression()
SqlUpdateIntoClause	Grammar production: nodeToken -> "UPDATE" nodeOptional -> [ SqlAllDistinctHint() ] nodeChoice -> ( "INTO" | "FOR" ) sqlIntoTable -> SqlIntoTable() nodeOptional1 -> [ SqlSelectWhereClause() | SqlWhereClause() ] nodeOptional2 -> [ SqlWithOptions() ]
SqlUpdateNewIntoClause	Grammar production: nodeToken -> "UPDATE" nodeOptional -> [ SqlAllDistinctHint() ] sqlOldNewHint -> SqlOldNewHint() nodeChoice -> ( "INTO" | "FOR" ) sqlIntoTable -> SqlIntoTable() nodeOptional1 -> [ SqlSelectWhereClause() | SqlWhereClause() ] nodeOptional2 -> [ SqlWithOptions() ]
SqlUpdateStatement	Grammar production: nodeToken -> "UPDATE" sqlTableReference -> SqlTableReference() nodeOptional -> [ RelObjectName() ] nodeToken1 -> "SET" sqlColumnValues -> SqlColumnValues() nodeOptional1 -> [ "WHERE" ( SqlExpression() | "CURRENT" "OF" RelObjectName() ) ] nodeToken2 -> ";"
SqlUpsertIntoClause	Grammar production: nodeToken -> "INSERT" nodeToken1 -> "OR" nodeToken2 -> "UPDATE" nodeOptional -> [ SqlAllDistinctHint() ] sqlIntoTableClause -> SqlIntoTableClause() nodeOptional1 -> [ SqlSelectWhereClause() | SqlWhereClause() ] nodeOptional2 -> [ SqlWithOptions() ]
SqlUpsertNewIntoClause	Grammar production: nodeToken -> "INSERT" nodeToken1 -> "OR" nodeToken2 -> "UPDATE" nodeOptional -> [ SqlAllDistinctHint() ] sqlOldNewHint -> SqlOldNewHint() sqlIntoTableClause -> SqlIntoTableClause() nodeOptional1 -> [ SqlSelectWhereClause() | SqlWhereClause() ] nodeOptional2 -> [ SqlWithOptions() ]
SqlVariableDeclaration	Grammar production: sqlTypeDeclaration -> SqlTypeDeclaration() nodeListOptional -> ( SqlInitDeclaration() )*
SqlViewDeclaration	Grammar production: nodeOptional -> ( SqlViewType() )?
SqlViewType	Grammar production: relObjectName -> RelObjectName()
SqlWhereClause	Grammar production: nodeToken -> "WHERE" sqlExpression -> SqlExpression()
SqlWhileLoop	Grammar production: nodeToken -> "WHILE" plSqlExpression -> PlSqlExpression() sqlNormalLoop -> SqlNormalLoop()
SqlWithOptions	Grammar production: nodeToken -> "WITH" nodeChoice -> ( SqlMaterializedCursor() | SqlForeignKeyFieldDeclaration() | SqlUniqueKeyFieldDeclaration() ) nodeListOptional -> ( "AND" ( SqlMaterializedCursor() | SqlForeignKeyFieldDeclaration() | SqlUniqueKeyFieldDeclaration() ) )*

Package smacs.sql.syntaxtree Description

JTB SqlTree.jtb Nodes