Package oracle.javatools.db.sql

Interface Summary

AliasFragment	SQLFragment that consists of an expression and an alias.
DBObjectUsage	Interface implemented by fragments that use a DBObjectID to refer to another DBObject.
DeclarativeSQLQuery	Extension of the SQLQuery interface that allows the query to edited.
FromObjectUsage	Interface implemented by any object that directly depends on a FromObject (e.g.
JoinCondition
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.
SQLQueryBuilder.SQLQueryObjectSet	A result set interface for the query builder class
ViewSQLQuery	Deprecated. - use DeclarativeSQLQuery

Class Summary

AbstractAliasFragment	SQLFragment that consists of an expression and an alias.
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.
AbstractSQLQueryBuilder	Abstract implementation of SQLQuery that performs functions generic to any builder.
ArithmeticOperation	Concrete subclass of Operation for arithmetic operations - ADD, SUBTRACT, MULTIPLY and DIVIDE.
AsteriskUsage	Deprecated. - use ColumnKeywordUsage
CaseStatement	Class to represent a case statement in a sql query.
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	Subclass of Operation for comparisons.
FKUsage	SQLFragment for the usage of a FKConstraint.
FromObject	Object that represents a clause in the FROM statement of a SQL query.
Function	Subclass of Operation for functions.
FunctionDefinition	Class used for defining built in functinos for the database.
GroupByObject	SQLFragment for the GROUP BY ...
IndexObject	Object to wrap each column eaxpression of the Index statement
JoinObject	Object that represent the JOIN clause of a SELECT statement (part of the FROM clause).
NonDeclarativeSQLQuery	Dummy SQLQuery that just contains a String representing the SQLQuery.
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
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.
SetOperation	SQLFragment for dealing with operations to do with sets and ranges like IN and BETWEEN.
SimpleSQLFragment	SQLFragment that we can't break down any more.
SQLQueryBuilderFactory	Factory class for creating a SQLQueryBuilder appropriate to the flavour of the DBObjectProvider and View.
SynonymUsage	SQLFragment for using a Synonym in a SQL query.
UsingJoinCondition	Object to represent the condition part of a JOIN that has a USING clause.
WhereObject	Object that represents a clause in the WHERE statement of a SQL query.

Exception Summary

AliasInUseException	SQLQueryException thrown when an attempt is made to add an object whose alias is already in use.
AmbiguousColumnException	Exception thrown when the name of a column in a query is ambiguous - i.e. it isn't qualified and it could refer to the column of more than one member of the FROM clause of a query.
IDException	Exception thrown when a DBObject is missing an ID.
SQLParseException	Subclass of SQLQueryException used for parse errors in the sql.
SQLQueryException	Superclass for all Exceptions thrown by the SQLQuery API.