| 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.hive | |
| 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 | 
 Utility classes for working with (for example parsing) PL/SQL. 
 | 
| 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.Long | 
Column.getPrecision()
Deprecated. 
 
- use getDataTypeUsage() and then get the appropriate attribute
 from the DataTypeUsage. 
e.g. dataTypeUsage.getAttributeValue( DataTypeAttribute.DATATYPE_PRECISION)  | 
java.lang.Long | 
Column.getScale()
Deprecated. 
 
- use getDataTypeUsage() and then get the appropriate attribute
 from the DataTypeUsage. 
e.g. dataTypeUsage.getAttributeValue( DataTypeAttribute.DATATYPE_SCALE)  | 
void | 
FKConstraint.setDeleteMode(int onDelete)
Deprecated. 
 
 | 
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 | 
View.setQueryRestriction(java.lang.String restriction)
Deprecated. 
 
 | 
void | 
Column.setScale(java.lang.Long scale)
Deprecated. 
 
- use getDataTypeUsage() and then set the appropriate attribute
 from the DataTypeUsage. 
e.g. dataTypeUsage.setAttributeValue( DataTypeAttribute.DATATYPE_SCALE)  | 
| Modifier and Type | Method and Description | 
|---|---|
java.lang.String | 
HiveStorageProperties.getCollectionItemDelim()
Gets the delimiter (terminator) String for collection items in the
 underlying data. 
 | 
java.lang.String | 
HiveStorageProperties.getFieldDelim()
Gets the delimiter (terminator) String for fields in the underlying
 data. 
 | 
java.lang.String | 
HiveStorageProperties.getFieldEscape()
Gets the escape String for the field terminator. 
 | 
java.lang.String | 
HiveStorageProperties.getLineDelim()
Gets the delimiter (terminator) String for lines in the
 underlying data. 
 | 
java.lang.String | 
HiveStorageProperties.getMapKeyDelim()
Gets the delimiter (terminator) String for map keys in the
 underlying data. 
 | 
java.lang.String | 
HiveStorageProperties.getNullFormat()
Gets the format String for the representation of null in the underlying
 data. 
 | 
void | 
HiveStorageProperties.setCollectionItemDelim(java.lang.String delim)
Sets the delimiter (terminator) String for collection items in the
 underlying data. 
 | 
void | 
HiveStorageProperties.setFieldDelim(java.lang.String delim)
Sets the delimiter (terminator) String for fields in the underlying
 data. 
 | 
void | 
HiveStorageProperties.setFieldEscape(java.lang.String fieldEscape)
Gets the escape String for the field terminator. 
 | 
void | 
HiveStorageProperties.setLineDelim(java.lang.String delim)
Sets the delimiter (terminator) String for lines in the
 underlying data. 
 | 
void | 
HiveStorageProperties.setMapKeyDelim(java.lang.String delim)
Sets the delimiter (terminator) String for map keys in the
 underlying data. 
 | 
void | 
HiveStorageProperties.setNullFormat(java.lang.String nullFormat)
Gets the format String for the representation of null in the underlying
 data. 
 | 
| 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 | 
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. 
 | 
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.setRewrite(boolean rewrite)
Deprecated. 
 
 | 
void | 
LOBDescriptor.setStorageEnabledInRow(boolean storageEnabledInRow)
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 | 
OracleStorageProperties.setTablespace(java.lang.String tablespace)
Deprecated. 
 
 | 
void | 
OracleIndexPartitions.setTablespaces(java.lang.String[] tablespaces)
Deprecated. 
 
Use setHashQuantityTablespaceIDs 
 | 
void | 
MaterializedView.setUseNoIndex(boolean useNoIndex)
Deprecated. 
 
 | 
| Modifier and Type | Method and Description | 
|---|---|
java.lang.String | 
Trigger.getBaseSchemaName()
Deprecated. 
 
- use getBaseObjectID 
 | 
java.lang.String | 
Trigger.getBaseSchemaName()
Deprecated. 
 
- use getBaseObjectID 
 | 
PlSqlBlock[] | 
PlSqlBlock.getBlocks()
Deprecated. 
 
Use super.getStatements() 
 | 
PlSqlBlock[] | 
PlSqlBlock.getBlocks()
Deprecated. 
 
Use super.getStatements() 
 | 
void | 
Trigger.setBaseSchemaName(java.lang.String baseSchemaName)
Deprecated. 
 
- use setBaseObjectID 
 | 
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). | 
void | 
PlSqlDatatype.setBaseTypeID(DBObjectID baseTypeID)
Deprecated. 
 
set the offset of the PlSqlReference that represents the
 base type instead using  
PlSqlDatatype.setBaseTypeOffset(Integer). | 
void | 
PlSqlBlock.setBlocks(PlSqlBlock[] blocks)
Deprecated. 
 
Use super.setStatements() 
 | 
void | 
PlSqlBlock.setBlocks(PlSqlBlock[] blocks)
Deprecated. 
 
Use super.setStatements() 
 | 
| 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 
 | 
FromObject | 
FKUsage.getRightFromObject()
Deprecated. 
 
- use getRightFromObjectID or resolveRightFromObject 
 | 
SelectObject | 
SelectObjectUsage.getSelectObject()
Deprecated. 
 
- use getSelectObjectID or resolveSelectObjectID 
 | 
void | 
ColumnUsage.setAlwaysQuote(boolean boo)  | 
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 | 
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 | 
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 
 |