Package gudusoft.gsqlparser.stmt.oracle

Class TPlsqlCreateTrigger

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TBlockSqlStatement

gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement

gudusoft.gsqlparser.stmt.oracle.TPlsqlCreateTrigger

All Implemented Interfaces:

IRelation, Visitable, Iterator<TSourceToken>

public class TPlsqlCreateTrigger
extends TCommonStoredProcedureSqlStatement

The CREATE TRIGGER statement creates or replaces a database trigger, which is either of the following:

• A stored PL/SQL block associated with a table, a schema, or the database.
• An anonymous PL/SQL block or a call to a procedure implemented in PL/SQL or Java.

For detailed information about Oracle simple_dml_trigger, compound_dml_trigger, non_dml_trigger Please check TTriggeringClause

the database automatically executes a trigger when specified conditions occur.

Nested Class Summary

Nested classes/interfaces inherited from class gudusoft.gsqlparser.TCustomSqlStatement

TCustomSqlStatement.SqlNormalizationProfile

Field Summary

Fields inherited from class gudusoft.gsqlparser.stmt.TBlockSqlStatement

blockBody, bodyStatements, declareStatements, exceptionClause

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

dummytag, fromClause, fromSourceJoin, fromSourceTable, isctequery, isparsed, joins, parser, plsqlparser, relationAttributes, rootNode, semicolonended, sourcetokenlist, sqlstatementtype, stmtScope, tables

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

dbvendor, doubleLinkedTokenListToString, nodeActionAppend, nodeActionInsert, nodeActionRemove, nodeActionUnknown, nodeActionUpdate, nodeActionUpdateText, nodeChangeEndToken, nodeChangeStartToken

Constructor Summary

Constructors

Constructor	Description
TPlsqlCreateTrigger(EDbVendor dbvendor)

Method Summary

Modifier and Type	Method	Description
void	accept(TParseTreeVisitor v)	Accept a visitor
void	acceptChildren(TParseTreeVisitor v)	Accept a visitor to iterate this class and sub-nodes of this class
int	doParseStatement(TCustomSqlStatement psql)
TParseTreeNode	getEventClause()	Deprecated. As of v2.0.1.0, replaced by getTriggeringClause() Indicates what's kind of trigger, can be one of these: TTriggeringClause,define a single trigger on a DML event. TCompoundDmlTriggerClause,define a compound trigger on a DML event. TNonDmlTriggerClause,define a single trigger on a DDL or database event.
TObjectNameList	getFollowsTriggerList()
TFunctionCall	getFunctionCall()	PostgreSQL executed function
TObjectName	getStoredProcedureName()
TCustomSqlStatement	getTriggerBody()	the PL/SQL block, PL/SQL compound trigger block, TCommonBlock
TTriggeringClause	getTriggeringClause()
TObjectName	getTriggerName()	The name of the trigger to be created.
TExpression	getWhenCondition()	A SQL condition that must be satisfied for the database to fire the trigger.
void	setEventClause(TParseTreeNode eventClause)
void	setFollowsTriggerList(TObjectNameList followsTriggerList)
void	setFunctionCall(TFunctionCall functionCall)
void	setTriggerBody(TCustomSqlStatement triggerBody)
void	setTriggerName(TObjectName triggerName)
void	setWhenCondition(TExpression whenCondition)

Methods inherited from class gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement

isWrapped, setWrapped

Methods inherited from class gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

getParameterDeclarations, getProcHandle, setParameterDeclarations, setProcHandle

Methods inherited from class gudusoft.gsqlparser.stmt.TBlockSqlStatement

getBlockBody, getBodyStatements, getDeclareStatements, getEndlabelName, getExceptionClause, getLabelName, getLabelNameStr, setBodyStatements, setDeclareStatements, setExceptionClause

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

addToTables, addWhereClause, analyzeFromTable, analyzeFromTable, analyzeJoin, analyzeTablename, analyzeTableOrJoin, asCanonical, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, computeSqlHash, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getAttributes, getColumnsInTable, getColumnsInTable, getCteIncludeThisStmt, getCteList, getDaxFunctionStack, getErrorCount, getErrormessage, getExpandedResultColumns, getFirstPhysicalTable, getFrameStack, getFromClause, getFromSourceJoin, getFromSourceTable, getGlobalScope, getIndexColumns, getJoins, getOrphanColumns, getOutputClause, getParentObjectName, getParentStmt, getQueryId, getRelationName, getRelations, getResultColumnList, getReturningClause, getSqlEnv, getSqlHash, getSqlHash, getStatements, getStmtScope, getSymbolTable, getSyntaxErrors, getSyntaxHints, getTables, getTargetTable, getTokenList, getTopClause, getTopStatement, getUsingVariableList, getVariableStack, getWhereClause, isathenaplsql, isBigQueryplsql, isdatabricksplsql, isGaussDBStoredProcedure, isgreeplumplsql, isnzplsql, isoracleplsql, ispgplsql, isprestoplsql, issnowflakeplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, parsestatement, searchCTEList, searchDaxVariableInStack, searchFunctionInSQLEnv, setAlreadyAddToParent, setCteIncludeThisStmt, setCteList, setEndlabelName, setFrameStack, setFromClause, setLabelName, setOutputClause, setParentStmt, setParentStmtToNull, setQueryId, setResultColumnList, setReturningClause, setSqlHash, setStmtScope, setTargetTable, setTopClause, setUsingVariableList, setVariableStack, setWhereClause, size, toNormalizedSql, toScript, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, doParse, fastSetString, getAnchorNode, getColumnNo, getCommentAfterNode, getCommentBeforeNode, getCompactString, getDummyTag, getEndToken, getEvaluateDatatype, getEvalValue, getGsqlparser, getLineNo, getLocation, getMd5, getNodeStatus, getNodeType, getPlainText, getStartToken, getTokenCount, hasNext, init, init, init, init, init, init, insertAfterAToken, insertNewNodeBeforeMe, isChanged, isTokensInChain, next, refreshAllNodesTokenCount, remove, removeAllMyTokensFromTokenList, removeTokens, removeTokensBetweenNodes, removeTokensBetweenToken, replaceWithNewNode, resetIterator, setAnchorNode, setChanged, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setEndToken, setEndTokenDirectly, setEvaluateDatatype, setEvalValue, setGsqlparser, setIncludingComment, setLocation, setNewSubNode, setNodeStatus, setNodeType, setParent, setPlainText, setStartToken, setStartToken, setStartToken, setStartToken, setStartTokenDirectly, setString, setString2, subNodeInNode, toString, toString2

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.util.Iterator

forEachRemaining

Constructor Details

TPlsqlCreateTrigger

public TPlsqlCreateTrigger(EDbVendor dbvendor)

Method Details

getTriggeringClause

public TTriggeringClause getTriggeringClause()

getStoredProcedureName

public TObjectName getStoredProcedureName()

Overrides:

getStoredProcedureName in class TStoredProcedureSqlStatement

setFunctionCall

public void setFunctionCall(TFunctionCall functionCall)

getFunctionCall

public TFunctionCall getFunctionCall()

PostgreSQL executed function

Returns:

function call

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCommonStoredProcedureSqlStatement

getTriggerName

public TObjectName getTriggerName()

The name of the trigger to be created.

Returns:

getEventClause

public TParseTreeNode getEventClause()

Deprecated.

As of v2.0.1.0, replaced by getTriggeringClause() Indicates what's kind of trigger, can be one of these:

• TTriggeringClause,define a single trigger on a DML event.
• TCompoundDmlTriggerClause,define a compound trigger on a DML event.
• TNonDmlTriggerClause,define a single trigger on a DDL or database event.

Returns:

trigger clause

getWhenCondition

public TExpression getWhenCondition()

A SQL condition that must be satisfied for the database to fire the trigger.

getTriggerBody

public TCustomSqlStatement getTriggerBody()

the PL/SQL block, PL/SQL compound trigger block, TCommonBlock

or call procedure that the database executes to fire the trigger.

Returns:

body statement of trigger

getFollowsTriggerList

public TObjectNameList getFollowsTriggerList()

accept

public void accept(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TBlockSqlStatement

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

acceptChildren

public void acceptChildren(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor to iterate this class and sub-nodes of this class

Specified by:

acceptChildren in interface Visitable

Overrides:

acceptChildren in class TBlockSqlStatement

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

setTriggerName

public void setTriggerName(TObjectName triggerName)

setEventClause

public void setEventClause(TParseTreeNode eventClause)

setWhenCondition

public void setWhenCondition(TExpression whenCondition)

setTriggerBody

public void setTriggerBody(TCustomSqlStatement triggerBody)

setFollowsTriggerList

public void setFollowsTriggerList(TObjectNameList followsTriggerList)