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 |
---|---|
Column[] |
ColumnConstraint.getColumns()
Retrieves the constrained columns.
|
DBObject |
AbstractDBObject.getParent() |
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. |
java.lang.Long |
Column.getScale()
Deprecated.
- use getDataTypeUsage() and then get the appropriate attribute
from the DataTypeUsage.
e.g. dataTypeUsage.getAttributeValue( DataTypeAttribute.DATATYPE_SCALE) |
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 |
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 |
AbstractChildBuildableObject.setParent(DBObject parent) |
void |
Index.setParent(DBObject par)
Sets the parent Table of this Index.
|
void |
AbstractChildDBObject.setParent(DBObject parent) |
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 |
Constraint.setRelation(Relation relation)
Sets the
Relation that owns this Constraint. |
void |
Column.setRelation(Relation relation)
Sets the
Relation that owns this Column. |
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 |
---|---|
java.lang.Class |
DataTypeID.getProviderClass()
Deprecated.
|
void |
DataTypeID.setProviderClass(java.lang.Class clz)
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 |
MaterializedView.setCompression(java.lang.Boolean compression)
Deprecated.
Compression is now stored in an OracleTableProperties object in
the Materialized View property map (as tableCompression), keyed by
OracleTableProperties.KEY
|
void |
TablePartition.setCompression(java.lang.String compression)
Deprecated.
Compression is now stored in an OracleTableProperties object in
the TablePartition property map, keyed by OracleTableProperties.KEY
|
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 |
MaterializedView.setParallel(int parallel)
Deprecated.
|
void |
MaterializedViewLog.setParallel(int parallel)
Deprecated.
|
void |
MaterializedView.setParallelDegree(java.lang.Integer parallel)
Deprecated.
ParallelDegree is now stored in an OracleTableProperties object in
the Materialized View property map, keyed by OracleTableProperties.KEY
|
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 |
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 |
OracleStorageProperties.setTablespace(java.lang.String tablespace)
Deprecated.
|
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
|
void |
PlSqlDatatype.setBaseTypeID(DBObjectID baseTypeID)
Deprecated.
set the offset of the PlSqlReference that represents the
base type instead using
PlSqlDatatype.setBaseTypeOffset(Integer) . |
protected void |
DBObjectPlSqlFragment.setSourceImpl(java.lang.String source) |
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 |
IndexObject.getName() |
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 |
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
|