| Package | Description | 
|---|---|
| oracle.ide.db.panels.sql | 
 UI for declaratively editing a SQL query. 
 | 
| 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 | 
|---|---|
SQLQuery | 
SQLQueryEditDialog.editQuery(SQLQuery query,
         DBObjectProvider provider,
         Schema defaultSchema)
Edits the given query. 
 | 
SQLQuery | 
SQLQueryEditDialog.editQuery(SQLQuery query,
         SQLFragment defaultObject,
         DBObjectProvider provider,
         Schema defaultSchema)
Edits the given query. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
Namespace | 
SQLQueryEditDialog.createNamespace(SQLQuery query,
               DBObjectProvider provider,
               Schema defaultSchema)
Creates a Namespace suitable for using as the basis of the Traversable
 mechanism when entering and exiting the sql query edit panels. 
 | 
SQLQuery | 
SQLQueryEditDialog.editQuery(SQLQuery query,
         DBObjectProvider provider,
         Schema defaultSchema)
Edits the given query. 
 | 
SQLQuery | 
SQLQueryEditDialog.editQuery(SQLQuery query,
         SQLFragment defaultObject,
         DBObjectProvider provider,
         Schema defaultSchema)
Edits the given query. 
 | 
static DBEditorConfig | 
SQLQueryEditDialog.newDefaultEditorConfig(DBObjectProvider pro,
                      SQLQuery query)
Creates a DBEditorConfig that can be put in the Namespace to edit a
 given query. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
SQLQuery | 
View.getSQLQuery()
Returns this view's query. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
View.setSQLQuery(SQLQuery query)
Sets this view's query. 
 | 
| Modifier and Type | Class and Description | 
|---|---|
class  | 
OracleSQLQuery
Deprecated. 
 
- folded in to SQLQuery 
 | 
| Modifier and Type | Method and Description | 
|---|---|
SQLQuery | 
MaterializedView.getSQLQuery()
Returns the query that defines the view as a SQLQuery object. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
MaterializedView.setSQLQuery(SQLQuery query)
Sets the query that defines the view. 
 | 
| Modifier and Type | Class and Description | 
|---|---|
class  | 
AbstractSQLQuery
Deprecated. 
 
- folded in to SQLQuery 
 | 
class  | 
NonDeclarativeSQLQuery
Deprecated. 
 
folded into SQLQuery 
 | 
| Modifier and Type | Method and Description | 
|---|---|
protected SQLQuery | 
AbstractSQLQueryBuilder.getQuery()  | 
SQLQuery | 
SQLQueryOwner.getSQLQuery()
Gets the SQLQuery from the owning object. 
 | 
SQLQuery | 
AbstractSQLQueryBuilder.getSQLQuery()  | 
SQLQuery | 
SQLQueryBuilder.getSQLQuery()
Returns the query that this builder is working on. 
 | 
SQLQuery | 
ModelObject.ReferenceModel.getSubquery()  | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
AbstractSQLQueryBuilder.buildDeclarativeProperties(SQLQuery query)
DerivedPropertyBuilder mechanism that directly builds the derived
 properties on the given SQLQuery. 
 | 
void | 
AbstractSQLQueryBuilder.buildQuery(SQLQuery query)  | 
void | 
SQLQueryBuilder.buildQuery(SQLQuery query)
Builds the query based on the given SQLQuery. 
 | 
protected abstract void | 
AbstractSQLQueryBuilder.buildQueryImpl(java.lang.String sql,
              SQLQuery query,
              SQLQueryOwner parent)
Builds the declarative components of the given SQLQuery based on the
 given select statement. 
 | 
protected boolean | 
AbstractSQLQueryBuilder.canCacheBuildFailure(SQLQuery object,
                    java.lang.String sourceProp)  | 
boolean | 
SQLQueryBuilder.cancelCurrentBuild(SQLQuery query)
Cancels any build that is currently in progress. 
 | 
java.util.Collection<java.lang.String> | 
AbstractSQLQueryBuilder.clearDerivedProperties(SQLQuery obj,
                      java.lang.String property,
                      DBObjectChange change)  | 
protected void | 
AbstractSQLQueryBuilder.derivePropertiesForTempCopy(SQLQuery object,
                           SQLQuery orig,
                           java.lang.String sourceProp)  | 
static java.util.List<SelectObject> | 
SQLFragmentUtils.expandStarColumns(SQLQuery query)
Gets an expanded list of SelectObjects for the given query that has any
 wildcard * columns expanded to the underlying table columns. 
 | 
SelectObjectUsage | 
AbstractSQLQueryBuilder.findColumnInSubQuery(java.lang.String colName,
                    boolean external,
                    SQLQuery query)  | 
static SQLQueryBuilder | 
SQLQueryBuilderFactory.findOrCreateBuilder(SQLQuery query,
                   DBObjectProvider pro)
As of 12.1.2 a DBObject's DerivedPropertyBuilder is held on that
 object. 
 | 
static SQLQueryBuilder | 
SQLQueryBuilderFactory.findOrCreateBuilder(SQLQuery query,
                   DBObjectProvider pro,
                   Schema defaultSchema)
As of 12.1.2 a DBObject's DerivedPropertyBuilder is held on that
 object. 
 | 
static SelectObject[] | 
SQLFragmentUtils.getSelectObjects(SQLQuery query)
Gets the SelectObjects for this query. 
 | 
static java.util.Set<java.lang.String> | 
SQLFragmentUtils.listFromObjectNames(SQLQuery query)
Lists the names of the FromObjects that are defined in the given query
 (does not include subqueries, just the namespace available in the current
 query). 
 | 
static void | 
SQLFragmentUtils.replaceStarColumns(SQLQuery query)
Alters the given SQLQuery so that any asterisk columns are expanded into
 multiple select objects. 
 | 
void | 
SQLQueryOwner.setSQLQuery(SQLQuery query)
Sets the SQLQuery on the owning object. 
 | 
protected void | 
AbstractSQLQueryBuilder.setSQLQuery(SQLQuery query)
Sets the query we are building. 
 | 
void | 
ModelObject.ReferenceModel.setSubquery(SQLQuery subQuery)  | 
| Constructor and Description | 
|---|
SQLQueryCancelledException(SQLQuery query)
Constructs a new exception to indicate that the declarative build of
 the given query has been cancelled. 
 |