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