Uses of Package
oracle.javatools.db.sql

Packages that use oracle.javatools.db.sql

oracle.ide.db.panels.sql	UI classes 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.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).
oracle.jdeveloper.engine.db
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

FKUsage
SQLFragment for the usage of a FKConstraint.

FromObject
Object that represents a clause in the FROM statement of a SQL query.

JoinObject
Object that represent the JOIN clause of a SELECT statement (part of the FROM clause).

SelectObject
Object that represents a clause in the SELECT statement of a SQL query.

SQLFragment
Interface for objects that encapsulate a fragment of SQL.

SQLQuery
Object that represents a basic SQL query.

SQLQueryBuilder
Interface that defines a builder class for sql queries.

SQLQueryBuilderFactory
Factory class for creating a SQLQueryBuilder.

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.

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

FromObject
Object that represents a clause in the FROM statement of a SQL query.

SQLFragment
Interface for objects that encapsulate a fragment of SQL.

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

IndexObject
Object to wrap each column eaxpression of the Index statement

InvalidSQLException
SQLQueryException for representing errors in the sql (e.g.

SQLFragment
Interface for objects that encapsulate a fragment of SQL.

SQLQuery
Object that represents a basic 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.ora

AbstractSQLFragment
Abstract superclass for SQLFragment implementations.

AbstractSQLQuery
Abstract implementation of a SQLQuery.

DeclarativeSQLQuery
Extension of the SQLQuery interface that allows the query to edited.

SQLFragment
Interface for objects that encapsulate a fragment of SQL.

SQLQuery
Object that represents a basic 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.sql

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.

AbstractSchemaObjectUsage
Abstract class for usages that reference a SchemaObject (e.g.

AbstractSQLFragment
Abstract superclass for SQLFragment implementations.

AbstractSQLQuery
Abstract implementation of a SQLQuery.

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.

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.

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
Class used for defining built in functinos for the database.

GroupByExpression.GroupingType

GroupByObject
SQLFragment for the GROUP BY ...

HierarchicalQueryObject
SQLFragment for the Hierarchical Query clause in a SQLQuery.

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).

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.

SimpleSQLFragment
SQLFragment that we can't break down any more.

SQLFragment
Interface for objects that encapsulate a fragment of SQL.

SQLFragmentExpressionBuilder.ExpressionType

SQLParseException
Subclass of SQLQueryException used for parse errors in the sql.

SQLQuery
Object that represents a basic SQL query.

SQLQueryBuilder
Interface that defines a builder class for sql queries.

SQLQueryBuilder.SQLQueryObjectSet
A result set interface for the query builder class

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.

WindowFunction.BoundType

WindowFunction.ClauseType

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

IndexObject
Object to wrap each column eaxpression of the Index statement

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

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