Package | Description |
---|---|
oracle.javatools.db |
Contains a metadata API for describing database objects, and retrieving them from a provider of database objects - for example a database.
|
oracle.javatools.db.datatypes |
Classes related to datatypes in the database API.
|
oracle.javatools.db.ora |
Contains the database api implementation for Oracle databases, and additional DBObject implementations for objects specific to Oracle.
|
oracle.javatools.db.plsql |
Classes for dealing with PL/SQL objects.
|
oracle.javatools.db.sql |
Contains an API for declaratively parsing SQL queries (SELECT statements).
|
oracle.jdeveloper.offlinedb |
Database API extension for saving database object definitions in XML files.
|
Modifier and Type | Method and Description |
---|---|
java.lang.String |
PlSqlSubprogram.getBody()
Deprecated.
|
java.lang.String |
PlSqlMethod.getBody()
Deprecated.
|
Column[] |
ColumnConstraint.getColumns()
Retrieves the constrained columns.
|
DataType |
PlSqlParameter.getDataType()
Deprecated.
use
PlSqlParameter.getDataTypeID() instead |
void |
PlSqlParameter.getDataType(DataType datatype)
Deprecated.
|
DBObject |
AbstractDBObject.getParent() |
DeclarativePlSql |
PlSqlParameter.getPlSql()
Deprecated.
Gets the PL/SQL routine that owns this parameter.
|
java.lang.Long |
Column.getPrecision()
Deprecated.
- use getDataTypeUsage() and then get the appropriate attribute from the DataTypeUsage.
e.g. dataTypeUsage.getAttributeValue( DataTypeAttribute.DATATYPE_PRECISION) |
DBObjectProvider |
BaseObjectID.getProvider()
INTERNAL USE ONLY.
Gets the provider this ID exists in. |
Relation |
Constraint.getRelation()
Gets the
Relation that owns this Constraint. |
Relation |
Column.getRelation()
Gets the
Relation that owns this Column. |
DataType |
Procedure.getReturnType()
Deprecated.
|
DataType |
PlSqlSubprogram.getReturnType()
Deprecated.
- use getReturnTypeID()
|
DataType |
PlSqlMethod.getReturnType()
Deprecated.
- use getReturnTypeID()
|
DBObjectID |
Procedure.getReturnTypeID()
Deprecated.
|
java.lang.Long |
Column.getScale()
Deprecated.
- use getDataTypeUsage() and then get the appropriate attribute from the DataTypeUsage.
e.g. dataTypeUsage.getAttributeValue( DataTypeAttribute.DATATYPE_SCALE) |
java.lang.String |
PlSqlSubprogram.getSignature()
Deprecated.
|
java.lang.String |
PlSqlMethod.getSignature()
Deprecated.
|
SpecPlSql |
PlSqlMethod.getSpecPlSql()
Deprecated.
Gets the
ComplexType that owns this method. |
SpecPlSql |
PlSqlAttribute.getSpecPlSql()
Deprecated.
Gets the
ComplexType that owns this attribute. |
Table |
Index.getTable()
Retrieves the table on which this index is defined.
|
java.lang.String |
View.getViewText()
Convenience method that returns the view's query in text format.
|
void |
PlSqlSubprogram.setBody(java.lang.String body)
Deprecated.
|
void |
PlSqlMethod.setBody(java.lang.String body)
Deprecated.
|
void |
CheckConstraint.setCheckConditionFragment(SQLFragment condition)
Sets the conditional expression represented by this constraint which is derived from the check condition.
|
void |
FKConstraint.setDeleteMode(int onDelete)
Deprecated.
|
void |
ViewColumn.setName(java.lang.String name)
Deprecated.
|
void |
Index.setParent(DBObject par)
Sets the parent Table of this Index.
|
void |
AbstractChildDBObject.setParent(DBObject parent) |
void |
AbstractChildBuildableObject.setParent(DBObject parent) |
void |
PlSqlParameter.setPlSql(DeclarativePlSql object)
Deprecated.
Sets the
ComplexType that owns this attribute. |
void |
Column.setPrecision(java.lang.Long precision)
Deprecated.
- use getDataTypeUsage() and then set the appropriate attribute from the DataTypeUsage.
e.g. dataTypeUsage.setAttributeValue( DataTypeAttribute.DATATYPE_PRECISION) |
void |
ProviderUsage.setProvider(DBObjectProvider pro)
Sets the provider this usage exists within.
|
void |
View.setQueryRestriction(java.lang.String restriction)
Deprecated.
|
void |
Trigger.setReferenceNames(java.lang.String[] names)
Deprecated.
|
void |
Constraint.setRelation(Relation relation)
Sets the
Relation that owns this Constraint. |
void |
Column.setRelation(Relation relation)
Sets the
Relation that owns this Column. |
void |
Procedure.setReturnType(DataType returnType)
Deprecated.
|
void |
PlSqlSubprogram.setReturnType(DataType returnType)
Deprecated.
- use setReturnTypeID()
|
void |
PlSqlMethod.setReturnType(DataType returnType)
Deprecated.
- use setReturnTypeID()
|
void |
Procedure.setReturnTypeID(DBObjectID returnTypeID)
Deprecated.
|
void |
PlSqlMethod.setSpecPlSql(SpecPlSql object)
Deprecated.
Sets the
ComplexType that owns this method. |
void |
PlSqlAttribute.setSpecPlSql(SpecPlSql plsql)
Deprecated.
Sets the
ComplexType that owns this attribute. |
void |
Trigger.setTableOwner(Schema owner)
Deprecated.
- see information on
Trigger.getTableOwner() . |
void |
View.setViewText(java.lang.String text)
Convinience method that sets the view's query to a NonDeclarativeSQLQuery from the given text.
|
void |
Column.setVirtualExpression(SQLFragment expression)
Sets the Virtual Expression for the Column.
|
Modifier and Type | Method and Description |
---|---|
void |
ComplexType.addDeclaratorError(java.lang.String error)
Deprecated.
|
java.util.List<java.lang.String> |
ComplexType.getDeclaratorErrors()
Deprecated.
|
boolean |
ComplexType.isMadeDeclarative()
Deprecated.
|
void |
ComplexType.setMadeDeclarative(boolean madeDeclarative)
Deprecated.
|
Modifier and Type | Method and Description |
---|---|
java.lang.String |
DatabaseLink.getAuthentificationPassword()
Retrieves the password for the authentification user.
|
java.lang.String |
DatabaseLink.getAuthentificationPasswordX()
Retrieves the encrypted password for the authentification user.
|
int |
MaterializedView.getIndexPercentUsed()
Deprecated.
You cannot specify the Percent Used for an Index. This method has been deprecated
|
java.lang.String[] |
MaterializedView.getMasters()
Deprecated.
|
java.lang.String |
OracleExternalTableProperties.LocationSpecifier.getName() |
java.lang.String |
MaterializedView.getNextRefresh()
Deprecated.
use getNextRefreshDate()
|
java.lang.String |
DatabaseLink.getPassword()
Retrieves the password for the user.
|
java.lang.String |
DatabaseLink.getPasswordX()
Retrieves the encrypted password for the user.
|
java.lang.String |
MaterializedView.getViewText()
Convinience method that returns the view's query in text format.
|
boolean |
DatabaseLink.isCurrentUser()
Deprecated.
use
DatabaseLink.getConnectToUser() instead. |
void |
DatabaseLink.setAuthentificationPassword(java.lang.String authentificationPassword)
Set the password for the authentification user
|
void |
DatabaseLink.setAuthentificationPasswordX(java.lang.String encryptedPassword)
Set the encrypted password for the authentification user.
|
void |
LOBDescriptor.setCache(java.lang.String cache)
|
void |
DatabaseLink.setCurrentUser(boolean currentUser)
Deprecated.
use
DatabaseLink.setConnectToUser(Boolean) instead. |
void |
OracleTablePartitions.setHashQuantityTablespaces(java.lang.String[] tablespaceNames)
Deprecated.
|
void |
MaterializedView.setIndexInitTrans(int indexInitTrans)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
MaterializedView.setIndexMaxExtent(int indexMaxExtent)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
MaterializedView.setIndexMinExtent(int indexMinExtent)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
MaterializedView.setIndexPercentFree(int indexPctFree)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
MaterializedView.setIndexPercentUsed(int indexPctUsed)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
MaterializedView.setInitExtent(int initExtent)
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
void |
MaterializedView.setMasters(java.lang.String[] masters)
Deprecated.
|
void |
MaterializedView.setMaxTrans(int maxTrans)
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
void |
MaterializedView.setMinTrans(int minTrans)
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
void |
MaterializedView.setNextExtent(int nextExtent)
Deprecated.
Storage properties of the Materialized View are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.KEY
|
void |
MaterializedView.setNextRefresh(java.lang.String nextStr)
Deprecated.
use setNextRefreshDate()
|
void |
MaterializedViewLog.setParallel(int parallel)
Deprecated.
|
void |
MaterializedView.setParallel(int parallel)
Deprecated.
|
void |
DatabaseLink.setPassword(java.lang.String password)
Set the password for the connention
|
void |
DatabaseLink.setPasswordX(java.lang.String encryptedPassword)
Set the encrypted password for the connention
|
void |
OracleStorageProperties.setTablespace(java.lang.String tablespace)
Deprecated.
|
void |
MaterializedView.setTablespace(java.lang.String tablespace)
Deprecated.
Storage properties of the Materialized View Index are stored on an OracleStorageProperties object in the Materialized View property map, keyed by OracleStorageProperties.MV_INDEX_KEY
|
void |
OracleIndexPartitions.setTablespaces(java.lang.String[] tablespaces)
Deprecated.
Use setHashQuantityTablespaceIDs
|
Modifier and Type | Method and Description |
---|---|
java.lang.String |
Trigger.getBaseSchemaName()
Deprecated.
- use getBaseObjectID
|
java.lang.String |
DBObjectPlSqlFragment.getSourceID() |
PlSqlSubProgram[] |
Type.getSubPrograms()
Convenience method, overloads the superclass getSubPrograms but will return the same as getMethods()
|
PlSqlVariable[] |
Type.getVariables()
Convenience method, overloads the superclass getVariables but will return the same as getAttributes()
|
void |
Trigger.setBaseSchemaName(java.lang.String baseSchemaName)
Deprecated.
- use setBaseObjectID
|
protected void |
DBObjectPlSqlFragment.setSourceImpl(java.lang.String source, boolean clearDerived) |
void |
Type.setSubPrograms(PlSqlSubProgram[] subPrograms)
Convenience method, overloads the superclass setSubPrograms but each entry in the array must be a PlSqlMethod or an IllegalArgumentExcption will be thrown.
|
void |
Type.setVariables(PlSqlVariable[] vars)
Convenience method, overloads the superclass setVariables but each entry in the array must be a PlSqlAttribute or an IllegalArgumentExcption will be thrown.
|
Modifier and Type | Method and Description |
---|---|
DataMiningFunction.DataMiningArguments |
DataMiningFunction.getDataMiningArguments()
Deprecated.
use getDmSpecificArgs
|
FromObject |
AbstractFromObjectUsage.getFromObject()
Deprecated.
- use setFromObjectID() instead
|
FromObject |
FKUsage.getLeftFromObject()
Deprecated.
- use getLeftFromObjectID or resolveLeftFromObject
|
java.lang.String |
AbstractAliasFragment.getName()
Gets a "name" for this fragment.
|
FromObject |
FKUsage.getRightFromObject()
Deprecated.
- use getRightFromObjectID or resolveRightFromObject
|
SelectObject |
SelectObjectUsage.getSelectObject()
Deprecated.
- use getSelectObjectID or resolveSelectObjectID
|
java.lang.Integer |
AbstractSQLFragment.getStartOffset() |
boolean |
SQLQuery.isDeclarative()
Tests whether this query has been fully built declaratively - i.e.
|
void |
ColumnUsage.setAlwaysQuote(boolean boo) |
void |
Comparison.setArguments(SQLFragment[] arguments) |
void |
SQLQuery.setDeclarative(boolean declarative)
Marks this query as declarative which means that the query string returned by getQueryString() matches the declarative parts available through the derived methods (e.g.
|
void |
SQLQuery.setDistinct(boolean isDistinct)
Set the DISTINCT/UNIQUE/ALL property for the query.
|
void |
SQLQuery.setDistinctSource(java.lang.String distinctSource)
Set the source string used to define the DISTINCT/UNIQUE/ALL property for the query
|
void |
IndexObject.setExpression(SQLFragment exp)
Sets the expression for this Index object which should be derived from the expression source.
|
void |
AbstractFromObjectUsage.setFromObject(FromObject from)
Deprecated.
- use setFromObjectID() instead
|
void |
SQLQuery.setFromObjects(FromObject[] froms)
Set all the from objects for this query - defining the FROM clause.
|
void |
SQLQuery.setGroupByObject(GroupByObject groupby)
Sets the "GROUP BY ...
|
void |
SQLQuery.setHierarchicalQueryObject(HierarchicalQueryObject connectby)
Set the "CONNECT BY ...
|
void |
FKUsage.setLeftFromObject(FromObject obj)
Deprecated.
- use getLeftFromObjectID or resolveLeftFromObject
|
void |
SQLQuery.setModelObject(ModelObject model)
Sets the MODEL clause of the query.
|
void |
AbstractAliasFragment.setName(java.lang.String name)
Does nothing for this fragment - an alias fragment's name is derived from it's alias or expression.
|
void |
IndexObject.setOrder(java.lang.String order)
Deprecated.
|
void |
SQLQuery.setOrderByObjects(OrderByObject[] orderBys)
Set all the OrderBy objects for this query - defining the ORDER BY clause.
|
void |
SQLQuery.setOrderSiblings(boolean orderSiblings)
Sets whether ORDER SIBLINGS BY is required by an hierarchical query.
|
void |
FKUsage.setRightFromObject(FromObject obj)
Deprecated.
- use setRightFromObjectID
|
void |
SelectObjectUsage.setSelectObject(SelectObject used)
Deprecated.
- use setSelectObjectID
|
void |
SQLQuery.setSelectObjects(SelectObject[] selects)
Set all the select objects for this query - defining the SELECT clause.
|
void |
SQLQuery.setSetOperator(SetOperator setOperator)
Set SET operator if query consists of one or more queries connected by one of the SET operators UNION, INTERSECT, MINUS or UNION ALL
|
void |
AbstractSQLFragment.setStartOffset(java.lang.Integer start) |
void |
SQLQuery.setWhereObject(WhereObject where)
Sets the WHERE clause for this query.
|
Modifier and Type | Method and Description |
---|---|
void |
OfflineDBObjectID.setID(java.lang.String id)
Deprecated.
use setIdentifer
|