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 |
SQLQueryBuilder.getSQLQuery()
Returns the query that this builder is working on.
|
SQLQuery |
AbstractSQLQueryBuilder.getSQLQuery() |
SQLQuery |
SQLQueryOwner.getSQLQuery()
Gets the SQLQuery from the owning object.
|
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 |
SQLQueryBuilder.buildQuery(SQLQuery query)
Builds the query based on the given SQLQuery.
|
void |
AbstractSQLQueryBuilder.buildQuery(SQLQuery query) |
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) |
void |
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.
|
protected void |
AbstractSQLQueryBuilder.setSQLQuery(SQLQuery query)
Sets the query we are building.
|
void |
SQLQueryOwner.setSQLQuery(SQLQuery query)
Sets the SQLQuery on the owning object.
|
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.
|