Package gudusoft.gsqlparser.sqlenv

Class TSQLOraclePackage

Object

gudusoft.gsqlparser.sqlenv.TSQLObject

gudusoft.gsqlparser.sqlenv.TSQLSchemaObject

gudusoft.gsqlparser.sqlenv.TSQLRoutine

gudusoft.gsqlparser.sqlenv.TSQLOraclePackage

public class TSQLOraclePackage
extends TSQLRoutine

SQL procedure

Field Summary

Fields inherited from class gudusoft.gsqlparser.sqlenv.TSQLObject

dataObjectType, name, nameKeepCase, sqlEnv

Constructor Summary

Constructors

Constructor	Description
TSQLOraclePackage(TSQLSchema sqlSchema, String packageName)

Method Summary

Modifier and Type	Method	Description
TSQLFunction	createFunction(String functionName)	create a function belong to this schema
TSQLProcedure	createProcedure(String procedureName)	create a procedure belong to this schema
protected TSQLSchemaObject	createSchemaObject(String schemaObjectName, ESQLDataObjectType dataObjectType)
protected TSQLSchemaObject	createSchemaObject(String schemaObjectName, ESQLDataObjectType dataObjectType, int priority)
TSQLTrigger	createTrigger(String triggerName)	create a trigger belong to this schema
List<TSQLSchemaObject>	getSchemaObjectList()

Methods inherited from class gudusoft.gsqlparser.sqlenv.TSQLRoutine

addParameter, addParameter, getDefinition, getParameter, getParameterList, searchParameter, setDefinition

Methods inherited from class gudusoft.gsqlparser.sqlenv.TSQLSchemaObject

getPriority, getQualifiedName, getSchema, setPriority

Methods inherited from class gudusoft.gsqlparser.sqlenv.TSQLObject

compareTo, compareTo, compareTo, compareTo, getDataObjectType, getName, getNameKeepCase, getSqlEnv, isDelimitedIdentifier, isDelimitedIdentifier, normalizeIdentifier, setDataObjectType

Methods inherited from class java.lang.Object

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

Constructor Details

TSQLOraclePackage

public TSQLOraclePackage(TSQLSchema sqlSchema,
 String packageName)

Method Details

createProcedure

public TSQLProcedure createProcedure(String procedureName)

create a procedure belong to this schema

Parameters:

procedureName - procedure name

Returns:

an instance of the SQL procedure

createFunction

public TSQLFunction createFunction(String functionName)

create a function belong to this schema

Parameters:

functionName - function name

Returns:

an instance of the SQL function.

createTrigger

public TSQLTrigger createTrigger(String triggerName)

create a trigger belong to this schema

Parameters:

triggerName - trigger name

Returns:

an instance of the SQL trigger.

createSchemaObject

protected TSQLSchemaObject createSchemaObject(String schemaObjectName,
 ESQLDataObjectType dataObjectType)

createSchemaObject

protected TSQLSchemaObject createSchemaObject(String schemaObjectName,
 ESQLDataObjectType dataObjectType,
 int priority)

getSchemaObjectList

public List<TSQLSchemaObject> getSchemaObjectList()