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) |