Table of Contents

Class TPlsqlCreateTrigger

Namespace
gudusoft.gsqlparser.stmt.oracle
Assembly
gudusoft.gsqlparser.dll

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.

the database automatically executes a trigger when specified conditions occur. 

public class TPlsqlCreateTrigger : TCommonStoredProcedureSqlStatement, Visitable
Inheritance
TPlsqlCreateTrigger
Implements
Inherited Members

Constructors

TPlsqlCreateTrigger(EDbVendor) 

public TPlsqlCreateTrigger(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Properties

EventClause

Indicates what's kind of trigger, can be one of these:

public virtual TParseTreeNode EventClause { get; set; }

Property Value

TParseTreeNode

trigger clause

FollowsTriggerList 

public virtual TObjectNameList FollowsTriggerList { get; set; }

Property Value

TObjectNameList

StoredProcedureName 

public override TObjectName StoredProcedureName { get; }

Property Value

TObjectName

TriggerBody

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

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

public virtual TCustomSqlStatement TriggerBody { get; set; }

Property Value

TCustomSqlStatement

body statement of trigger

TriggerName

The name of the trigger to be created. @return

public virtual TObjectName TriggerName { get; set; }

Property Value

TObjectName

WhenCondition

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

public virtual TExpression WhenCondition { get; set; }

Property Value

TExpression

Methods

accept(TParseTreeVisitor) 

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor) 

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParseStatement(TCustomSqlStatement)

analyze SQL

public override int doParseStatement(TCustomSqlStatement psql)

Parameters

psql TCustomSqlStatement

Returns

int
Edit this page