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 |
SQLQueryBuilder.getSQLQuery()
Returns the query that this builder is working on.
|
SQLQuery |
AbstractSQLQueryBuilder.getSQLQuery() |
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.
|
java.util.Collection<java.lang.String> |
AbstractSQLQueryBuilder.clearDerivedProperties(SQLQuery obj, java.lang.String property, DBObjectChange change) |
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) |