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.ora.bigdata | |
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 |
Column.getRelation()
Gets the
Relation that owns this Column. |
Relation |
Constraint.getRelation()
Gets the
Relation that owns this Constraint. |
Modifier and Type | Method and Description |
---|---|
protected void |
ColumnConstraint.addColumnImpl(Column col,
Relation relForColumn) |
protected void |
PKConstraint.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 |
Column.setRelation(Relation relation)
Sets the
Relation that owns this Column. |
void |
Constraint.setRelation(Relation relation)
Sets the
Relation that owns this Constraint. |
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 java.util.List<java.lang.String> |
BigDataAccessParameterMetadata.getAllowedParameterValues(java.lang.String paramName,
Relation relation,
DBObjectProvider pro)
Gets the allowed values for the given parameter name.
|
static java.util.Collection<java.lang.String> |
BigDataJsonEntry.getAllowedValueStrings(java.lang.String entryName,
java.lang.String paramName,
Relation table)
Gets the allow values for the given json entry value as Strings.
|
static boolean |
BigDataAccessParameterMetadata.hasAllowedParameterValues(java.lang.String paramName,
Relation relation,
DBObjectProvider pro)
Tests whether the given named parameter has listable allowed values.
|
Modifier and Type | Method and Description |
---|---|
static Relation |
SQLFragmentUtils.getTable(FromObject from) |
Modifier and Type | Method and Description |
---|---|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructFromObjects(Relation[] baseRelations,
boolean createSelectObjects,
boolean createJoins,
FromObject[] includeInJoins) |
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructFromObjects(Relation[] baseRelations,
boolean createSelectObjects,
boolean createJoins,
FromObject[] includeInJoins)
Creates one or more FromObjects for the query.
|
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, name) instead |
PKConstraint |
OfflineDBObjectFactory.newPKConstraint(java.lang.String name,
Relation parent)
Deprecated.
as of 11.1.1 call
newObject(PKConstraint.class, parent, name) instead |
UniqueConstraint |
OfflineDBObjectFactory.newUniqueConstraint(java.lang.String name,
Relation parent)
Deprecated.
as of 11.1.1 call
newObject(UniqueConstraint.class, parent, name) instead |