Skip navigation links

Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference
11g Release 1 (11.1.1.5.0)

E13403-06


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.

 


Skip navigation links

Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference
11g Release 1 (11.1.1.5.0)

E13403-06


Copyright © 1997, 2011, Oracle. All rights reserved.