Uses of Package
oracle.javatools.db.sql

Packages that use oracle.javatools.db.sql

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.

Classes in oracle.javatools.db.sql used by oracle.ide.db.panels.sql

Class and Description
SQLFragment Interface for objects that encapsulate a fragment of SQL.
SQLQuery Object that represents a SQL query.

Classes in oracle.javatools.db.sql used by oracle.ide.db.util

Class and Description
SQLFragment Interface for objects that encapsulate a fragment of SQL.

Classes in oracle.javatools.db.sql used by oracle.javatools.db

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.

Classes in oracle.javatools.db.sql used by oracle.javatools.db.hive

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.

Classes in oracle.javatools.db.sql used by oracle.javatools.db.ora

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.

Classes in oracle.javatools.db.sql used by oracle.javatools.db.ora.bigdata

Class and Description
AbstractSQLFragment Abstract superclass for SQLFragment implementations.
SQLFragment Interface for objects that encapsulate a fragment of SQL.

Classes in oracle.javatools.db.sql used by oracle.javatools.db.plsql

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)

Classes in oracle.javatools.db.sql used by oracle.javatools.db.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

Classes in oracle.javatools.db.sql used by oracle.jdeveloper.offlinedb

Class and Description
SQLQueryOwner Interfaced to be implemented by any object that can own a SQLQuery.