Package | Description |
---|---|
oracle.ide.db.panels.sql |
UI for declaratively editing a SQL query.
|
oracle.ide.db.util |
Utility classes for dealing with database objects in UI in the IDE.
|
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.hive | |
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.plsql |
Utility classes for working with (for example parsing) PL/SQL.
|
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.
|
Class and Description |
---|
SQLFragment
Interface for objects that encapsulate a fragment of SQL.
|
SQLQuery
Object that represents a SQL query.
|
Class and Description |
---|
SQLFragment
Interface for objects that encapsulate a fragment of SQL.
|
Class and Description |
---|
BuiltInFunction
Class used for defining built in functions for the database.
|
IndexObject
Object to wrap a column expression (usually just a name, but could be any
sql expression) with an optional order type (ASC/DESC).
|
InvalidSQLException
SQLQueryException for representing errors in the sql (e.g.
|
SqlAliasExpander
A utility to resolve table alaiases in SQL so that a list of
Usages can be returned, each with a List<String> and
int offsets. |
SQLFragment
Interface for objects that encapsulate a fragment of SQL.
|
SQLQuery
Object that represents a SQL query.
|
SQLQueryBuilderFactory
Factory class for creating a SQLQueryBuilder.
|
SQLQueryOwner
Interfaced to be implemented by any object that can own a SQLQuery.
|
Class and Description |
---|
AbstractSQLFragment
Abstract superclass for SQLFragment implementations.
|
IndexObject
Object to wrap a column expression (usually just a name, but could be any
sql expression) with an optional order type (ASC/DESC).
|
SQLFragment
Interface for objects that encapsulate a fragment of SQL.
|
Class and Description |
---|
AbstractSQLFragment
Abstract superclass for SQLFragment implementations.
|
AbstractSQLQuery
Deprecated.
- folded in to SQLQuery
|
DeclarativeSQLQuery
Deprecated.
- incorporated in to SQLQuery
|
SQLFragment
Interface for objects that encapsulate a fragment of SQL.
|
SQLQuery
Object that represents a SQL query.
|
SQLQueryOwner
Interfaced to be implemented by any object that can own a SQLQuery.
|
Class and Description |
---|
AbstractSQLFragment
Abstract superclass for SQLFragment implementations.
|
SQLFragment
Interface for objects that encapsulate a fragment of SQL.
|
Class and Description |
---|
SQLCallable
Defines a callable method from within SQL (or PL/SQL)
|
SQLCallableArgument
Defines an argument of a callable method from within SQL (or PL/SQL)
|
Class and Description |
---|
AbstractAliasFragment
SQLFragment that consists of an expression and an alias.
|
AbstractDBObjectUsage
Abstract implementation for a SQLFragment that uses another DBObject (e.g
a Column) through a FromObject in the query.
|
AbstractFromObjectUsage
Abstract SQLFragment implementation of FromObjectUsage.
|
AbstractProviderUsageSQLFragment
Abstract SQLFragment implementation that is also a ProviderUsage.
|
AbstractSchemaObjectUsage
Abstract class for usages that reference a SchemaObject (e.g.
|
AbstractSQLFragment
Abstract superclass for SQLFragment implementations.
|
AbstractSQLQuery
Deprecated.
- folded in to SQLQuery
|
AbstractSQLQueryBuilder
Abstract implementation of SQLQuery that performs functions generic to any
builder.
|
AbstractSQLQueryBuilder.QueryColumnInfo |
AliasFragment
SQLFragment that consists of an expression and an alias.
|
AliasInUseException
SQLQueryException thrown when an attempt is made to add an object whose
alias is already in use.
|
ArithmeticOperation.ArithmeticOperator
Valid arithmetic operators.
|
BuiltInFunctionArgument
An argument to a SQL Built-in Function
|
CaseStatement.WhenThen |
ColumnKeywordUsage
A FromObjectUsage that has a keyword for the Column name, rather than an
actual column.
|
ColumnUsage
SQL fragment that is a use of a Column.
|
Comparison.Comparator
Valid comparators for SQL.
|
DataMiningFunction.DataMiningArguments
Deprecated.
no longer required, use get/setDmSpecificArgs directly.
|
DBObjectUsage
Interface implemented by fragments that use a DBObjectID to refer to another
DBObject.
|
ExpressionList
List of expressions.
|
FKUsage
SQLFragment for the usage of a FKConstraint.
|
FromObject
Object that represents a clause in the FROM statement of a SQL query.
|
FromObjectUsage
Interface implemented by any object that directly depends on a FromObject
(e.g.
|
Function
Subclass of Operation for functions.
|
FunctionDefinition
Deprecated.
- Use
BuiltInFunction |
FunctionUsage |
GroupByExpression.GroupingType |
GroupByObject
SQLFragment for the GROUP BY ...
|
HierarchicalQueryObject
SQLFragment for the Hierarchical Query clause in a SQLQuery.
|
IndexObject.OrderType |
InvalidAliasException
Exception thrown when a select or from object has an invalid alias (e.g.
|
InvalidSQLException
SQLQueryException for representing errors in the sql (e.g.
|
JoinCondition |
JoinObject
Object that represent the JOIN clause of a SELECT statement (part of the
FROM clause).
|
ModelObject
SQLFragment for the MODEL clause in a SQLQuery.
|
ModelObject.CellReferenceOptions |
OnJoinCondition
Object to represent the ON condition of a JOIN clause.
|
Operation
Abstract class for operations.
|
OrderByObject
Object to wrap each part of the ORDER BY clause of a SQLQuery.
|
ParserUtils.ExpressionType |
RelationUsage
SQL fragment that is a use of a Relation.
|
SelectObject
Object that represents a clause in the SELECT statement of a SQL query.
|
SelectObjectUsage
Class that represents the usage of a SelectObject.
|
SequenceUsage.Mode
Representation of how the sequence is used in the query
|
SetOperation.Operator
Valid operators for a SetOperation.
|
SetOperator
SQLFragment for dealing with queries that are linked using one of the SET
operators INTERSECT, UNION, MINUS and UNION ALL.
|
SetOperator.Operator
Valid operators for a SetOperator.
|
SimpleSQLFragment
SQLFragment that we can't break down any more.
|
SqlAliasExpander.Usage |
SQLCallable
Defines a callable method from within SQL (or PL/SQL)
|
SQLCallableArgument
Defines an argument of a callable method from within SQL (or PL/SQL)
|
SQLFragment
Interface for objects that encapsulate a fragment of SQL.
|
SQLFragmentExpressionBuilder.ExpressionType |
SQLFragmentFactory |
SQLFragmentWithDatatype
A SQLFragment that has a datatype, for example, a ColumnUsage or an Operation.
|
SQLParseException.ParseError |
SQLQuery
Object that represents a SQL query.
|
SQLQueryBuilder
Interface that defines a builder class for sql queries.
|
SQLQueryBuilder.SQLQueryObjectSet
A result set interface for the query builder class
|
SQLQueryCancelledException
SQLQueryException thrown when the build of a SQLQuery is interrupted or
cancelled by the user.
|
SQLQueryClauseException
Exception thrown by a SQLQueryBuilder when there is an error with a clause
in the query, but that this error doesn't stop the query being declarative.
|
SQLQueryException
Superclass for all Exceptions thrown by the SQLQuery API.
|
SQLQueryOwner
Interfaced to be implemented by any object that can own a SQLQuery.
|
WhereObject
Object that represents a clause in the WHERE statement of a SQL query.
|
WhereObject.WhereOperator
Valid operators for a WhereObject.
|
WindowFunction.BoundType |
WindowFunction.ClauseType |
WindowFunction.FromPolicy |
WindowFunction.NullPolicy |
Class and Description |
---|
SQLQueryOwner
Interfaced to be implemented by any object that can own a SQLQuery.
|