| 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.ora | 
 Contains the database api implementation for Oracle databases, and additional
DBObject implementations for objects specific to Oracle. 
 | 
| oracle.javatools.db.sql | 
 Contains an API for declaratively parsing SQL queries (SELECT statements). 
 | 
| Modifier and Type | Method and Description | 
|---|---|
Column | 
Relation.getColumn(java.lang.String name)
Retrieves a column by name. 
 | 
Column[] | 
ColumnConstraint.getColumns()
Retrieves the constrained columns. 
 | 
Column[] | 
Relation.getColumns()
Retrieves the list of columns contained in this relation. 
 | 
Column[] | 
View.getColumns()  | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
ColumnConstraint.addColumn(Column col)
Adds a constrained column. 
 | 
void | 
Relation.addColumn(Column col)
Adds one column to this relation. 
 | 
void | 
Relation.addColumn(int index,
         Column col)
Adds one column to this relation at the given index. 
 | 
protected void | 
ColumnConstraint.addColumnImpl(Column col,
             Relation relForColumn)  | 
protected void | 
PKConstraint.addColumnImpl(Column col,
             Relation relForColumn)  | 
static boolean | 
ColumnConstraint.isConstrained(Column col,
             java.lang.String... constraintTypes)
Tests whether the given Column appears in any ColumnConstraint on its
 owning table of given constraint types. 
 | 
static boolean | 
UniqueConstraint.isUnique(Column col)
Returns true if the given table is constrained by a UniqueConstraint
 (including PKConstraint) in its parent table. 
 | 
boolean | 
ColumnConstraint.removeColumn(Column col)
Removes a column from the list of constrained columns. 
 | 
void | 
Relation.removeColumn(Column col)
Removes a column from this relation. 
 | 
void | 
ColumnConstraint.setColumns(Column[] columns)
Sets the constrained columns. 
 | 
void | 
Relation.setColumns(Column[] newCols)
Sets the entire list of columns, replacing any that have previously
 been added. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
Column[] | 
MaterializedView.getColumns()  | 
static Column[] | 
OracleIndexPartitions.getValidGlobalPartitionColumns(Index index)
Returns an array of columns that are eligible for global index partitioning. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
static boolean | 
LOBDescriptor.isLOBColumn(Column column)
Tests whether the given Column's datatype is a LOB type. 
 | 
static boolean | 
LOBDescriptor.isVARRAYColumn(Column column)
Tests whether the given Column's datatype is a VARRAY type. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
Column[] | 
AbstractSQLQueryBuilder.getColumns()  | 
Column[] | 
SQLQueryBuilder.getColumns()
Retrieves Column objects mapped to the columns in the SQL query that has
 been built, thereby giving the name and type of each column the query
 has. 
 | 
protected Column[] | 
AbstractSQLQueryBuilder.getColumnsFromResultSet()  | 
| Modifier and Type | Method and Description | 
|---|---|
static java.util.Collection<Column> | 
SQLFragmentUtils.listColumns(SQLFragment expression)
Deprecated. 
 
- Columns availble from  
SQLQueryBuilder.getColumns() | 
| Modifier and Type | Method and Description | 
|---|---|
SQLQueryBuilder.SQLQueryObjectSet | 
AbstractSQLQueryBuilder.constructSelectObject(Column col,
                     FromObject usageToUse)  | 
SQLQueryBuilder.SQLQueryObjectSet | 
SQLQueryBuilder.constructSelectObject(Column col,
                     FromObject usageToUse)
Creates a SelectObject for the query based on the column passed in. 
 | 
SQLQueryBuilder.SQLQueryObjectSet | 
AbstractSQLQueryBuilder.constructSelectObjects(Column[] baseCols,
                      FromObject[] usagesToUse)  | 
SQLQueryBuilder.SQLQueryObjectSet | 
SQLQueryBuilder.constructSelectObjects(Column[] baseCols,
                      FromObject[] usagesToUse)
Creates a set of SelectObjects for the query based on the columns passed in. 
 | 
protected SelectObject | 
AbstractSQLQueryBuilder.doConstructSelectObject(Column col,
                       java.util.Map<DBObjectID,FromObject> relsToUse,
                       java.util.Map<DBObjectID,FromObject> newRels,
                       java.util.List<java.lang.String> relNames,
                       java.util.List<java.lang.String> colNames)  | 
protected void | 
AbstractSQLQueryBuilder.setViewColDataType(Column col,
                  SelectObject so)  | 
| Modifier and Type | Method and Description | 
|---|---|
protected FromObject | 
AbstractSQLQueryBuilder.doConstructFromObject(SchemaObject relation,
                     java.util.List<DBObjectID> baseRelIDs,
                     java.util.List<java.lang.String> relNames,
                     java.util.Map<DBObjectID,FromObject> newRels,
                     java.util.List<Column> cols,
                     java.util.List<FKConstraint> fks)  |