| 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).
|
| oracle.jdeveloper.offlinedb |
Database API extension for saving database object definitions in XML files.
|
| Modifier and Type | Class and Description |
|---|---|
class |
Table
Model of a database table.
|
class |
View
Represents a database View.
|
| Modifier and Type | Method and Description |
|---|---|
Relation |
Constraint.getRelation()
Gets the
Relation that owns this Constraint. |
Relation |
Column.getRelation()
Gets the
Relation that owns this Column. |
| Modifier and Type | Method and Description |
|---|---|
protected void |
PKConstraint.addColumnImpl(Column col, Relation relForColumn) |
protected void |
ColumnConstraint.addColumnImpl(Column col, Relation relForColumn) |
static SQLFragment |
DBUtil.getColumnExpressionFragment(java.lang.String expression, Relation rel, DBObjectProvider pro, boolean quoteColumns)
Construct a SQLFragment for the given Column Expression
|
static java.util.Collection<Constraint> |
Constraint.getConstraints(Relation rel, java.lang.String... types)
Lists the constraints on a given Relation that are of the given constraint types.
|
static PKConstraint |
PKConstraint.getPrimaryKey(Relation table)
Returns a primary key for the given table, if it owns one.
|
void |
Constraint.setRelation(Relation relation)
Sets the
Relation that owns this Constraint. |
void |
Column.setRelation(Relation relation)
Sets the
Relation that owns this Column. |
| Constructor and Description |
|---|
CheckConstraint(java.lang.String name, Relation relation)
Constructs a new CheckConstraint for a relation with a specific name.
|
Constraint(java.lang.String name, Relation relation)
Constructs a new Constraint on a relation with a specific name, and adds the constraint to the relation.
|
FKConstraint(java.lang.String name, Relation relation)
Constructs a new FKConstraint with the specified name for the specified relation.
|
PKConstraint(java.lang.String name, Relation relation)
Constructs a new PKConstraint for the specified Relation with the specified name.
|
UniqueConstraint(java.lang.String name, Relation relation)
Creates a new Constraint of the specified name for the specified relation.
|
| Modifier and Type | Class and Description |
|---|---|
class |
MaterializedView
A MaterializedView represents a Materialized View in the database.
|
| Modifier and Type | Method and Description |
|---|---|
static Relation |
SQLFragmentUtils.getTable(FromObject from) |
| Modifier and Type | Method and Description |
|---|---|
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructFromObjects(Relation[] baseRelations, boolean createSelectObjects, boolean createJoins, FromObject[] includeInJoins)
Creates one or more FromObjects for the query.
|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructFromObjects(Relation[] baseRelations, boolean createSelectObjects, boolean createJoins, FromObject[] includeInJoins) |
FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInRelation(java.lang.String colName, boolean external, Relation rel)
Finds a Column with the given name in a Relation and returns a FromObjectUsage that references that column.
|
static java.util.Collection<java.lang.String[]> |
ParserUtils.getColumnNames(java.lang.String expression, SQLFragmentExpressionBuilder.ExpressionType type, DBObjectProvider prov, Relation rel)
Returns a Collection of names of the columns used in
expression. |
static SQLFragment |
SQLFragmentExpressionBuilder.getExpression(DBObjectProvider provider, Relation relation, SQLFragmentExpressionBuilder.ExpressionType type, java.lang.String expression)
For the given relation in the given provider, creates a SQLFragment condition representing the condition (such as a where clause predicate or check constraint) If the parser fails, return a SimpleSQLFragment for the expression string.
|
static SQLFragment |
SQLFragmentExpressionBuilder.getExpression(DBObjectProvider provider, Relation relation, SQLFragmentExpressionBuilder.ExpressionType type, java.lang.String expression, boolean ignorErrors)
Deprecated.
|
static SQLFragment |
SQLFragmentExpressionBuilder.getExpressionOrFail(DBObjectProvider provider, Relation relation, SQLFragmentExpressionBuilder.ExpressionType type, java.lang.String expression)
For the given relation in the given provider, creates a SQLFragment condition representing the condition (such as a where clause predicate or check constraint)
|
void |
AbstractSQLQueryBuilder.setSingleRelation(Relation singleRelation) |
| Modifier and Type | Method and Description |
|---|---|
FKConstraint |
OfflineDBObjectFactory.newFKConstraint(java.lang.String name, Relation parent)
Deprecated.
as of 11.1.1 call
newObject(FKConstraint.class, parent) instead |
PKConstraint |
OfflineDBObjectFactory.newPKConstraint(java.lang.String name, Relation parent)
Deprecated.
as of 11.1.1 call
newObject(PKConstraint.class, parent) instead |
UniqueConstraint |
OfflineDBObjectFactory.newUniqueConstraint(java.lang.String name, Relation parent)
Deprecated.
as of 11.1.1 call
newObject(UniqueConstraint.class, parent) instead |