oracle.javatools.db.sql
Interface SQLFragment
- All Superinterfaces:
- ChildDBObject, Copyable, DBObject, DynamicPropertySet
- All Known Subinterfaces:
- AliasFragment, DBObjectUsage, DeclarativeSQLQuery, FromObjectUsage, JoinCondition, SQLQuery
- All Known Implementing Classes:
- AbstractAliasFragment, AbstractDBObjectUsage, AbstractFromObjectUsage, AbstractSchemaObjectUsage, AbstractSQLFragment, AbstractSQLQuery, ArithmeticOperation, AsteriskUsage, CaseStatement, CaseStatement.WhenThen, ColumnKeywordUsage, ColumnUsage, Comparison, DataMiningFunction, DataMiningFunction.DataMiningArguments, ExpressionList, FKUsage, FromObject, Function, FunctionUsage, GroupByExpression, GroupByObject, HierarchicalQueryObject, IndexObject, JoinObject, NonDeclarativeSQLQuery, OnJoinCondition, Operation, OracleSQLQuery, OrderByObject, PlSqlUsage, RelationUsage, SelectObject, SelectObjectUsage, SetOperation, SimpleSQLFragment, SynonymUsage, UsingJoinCondition, WhereObject, WindowFunction, WindowFunction.WindowFunctionBound
public interface SQLFragment
- extends ChildDBObject
Interface for objects that encapsulate a fragment of SQL. These fragments
should contain no validation - all logic to do with the structure and
validity of a SQLQuery and its fragments should be contained in the
appropriate SQLQueryBuilder. This allows different database/object
implementations easier to write, and make the SQLQuery itself more flexible.
The SQLFragment interface includes methods for getting and setting generic
properties on a fragment (like DBObject). This is for users of the objects
(e.g. SQLQueryBuilder, the Database Modeler etc).
- Since:
- 10.1.3
Field Summary |
static java.lang.String |
CONNECTBY
|
static java.lang.String |
FROM
|
static java.lang.String |
GROUPBY
|
static java.lang.String |
HAVING
|
static java.lang.String |
NOCYCLE
|
static java.lang.String |
ORDERBY
|
static java.lang.String |
SELECT
|
static java.lang.String |
STARTWITH
|
static java.lang.String |
TYPE
|
static java.lang.String |
WHERE
|
Method Summary |
java.lang.String |
getSQLText()
Return the SQL for this fragment. |
Methods inherited from interface oracle.javatools.db.DBObject |
copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, getType, replaceReferenceIDs, setID, setName |
TYPE
static final java.lang.String TYPE
- See Also:
- Constant Field Values
SELECT
static final java.lang.String SELECT
- See Also:
- Constant Field Values
FROM
static final java.lang.String FROM
- See Also:
- Constant Field Values
WHERE
static final java.lang.String WHERE
- See Also:
- Constant Field Values
ORDERBY
static final java.lang.String ORDERBY
- See Also:
- Constant Field Values
GROUPBY
static final java.lang.String GROUPBY
- See Also:
- Constant Field Values
HAVING
static final java.lang.String HAVING
- See Also:
- Constant Field Values
CONNECTBY
static final java.lang.String CONNECTBY
- See Also:
- Constant Field Values
STARTWITH
static final java.lang.String STARTWITH
- See Also:
- Constant Field Values
NOCYCLE
static final java.lang.String NOCYCLE
- See Also:
- Constant Field Values
getSQLText
java.lang.String getSQLText()
- Return the SQL for this fragment. This contains no validation - if the
implementation is incomplete it will just return what it has. Error
checking of fragments should be done using a SQLQueryBuilder.
- Returns:
- a string representing the SQL text for this object.
Copyright © 1997, 2011, Oracle. All rights reserved.