|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1) E13403-04 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object oracle.javatools.db.AbstractDBObject oracle.javatools.db.AbstractChildDBObject oracle.javatools.db.sql.AbstractSQLFragment oracle.javatools.db.sql.CaseStatement
public class CaseStatement
Class to represent a case statement in a sql query.
CASE [expression]
WHEN condition THEN thenExpression
WHEN condition THEN thenExpression ...
[ELSE elseExpression]
END
Nested Class Summary | |
---|---|
static class |
CaseStatement.WhenThen
|
Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject |
---|
AbstractDBObject.ChildSupport |
Field Summary | |
---|---|
static java.lang.String |
CASE
|
static java.lang.String |
ELSE
|
static java.lang.String |
END
|
static java.lang.String |
THEN
|
static java.lang.String |
WHEN
|
Fields inherited from class oracle.javatools.db.sql.AbstractSQLFragment |
---|
DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, NEWLINE, SPACE |
Fields inherited from interface oracle.javatools.db.sql.SQLFragment |
---|
CONNECTBY, FROM, GROUPBY, HAVING, NOCYCLE, ORDERBY, SELECT, STARTWITH, TYPE, WHERE |
Fields inherited from interface oracle.javatools.db.DBObject |
---|
COMMENT |
Constructor Summary | |
---|---|
CaseStatement()
|
|
CaseStatement(CaseStatement.WhenThen[] whenThens)
CASE WHEN condition THEN thenExpression ... |
|
CaseStatement(CaseStatement.WhenThen[] whenThens,
SQLFragment elseExpression)
CASE WHEN condition THEN thenExpression ... |
|
CaseStatement(SQLFragment expression,
CaseStatement.WhenThen[] whenThens)
CASE expression WHEN condition THEN thenExpression ... |
|
CaseStatement(SQLFragment expression,
CaseStatement.WhenThen[] whenThens,
SQLFragment elseExpression)
CASE expression WHEN condition THEN thenExpression ... |
Method Summary | |
---|---|
DBObject |
copyTo(DBObject target,
DBObject copyParent,
IDPolicy idPolicy)
Internal copy method used by the API to perform copy operations. |
protected void |
copyToImpl(CaseStatement copy,
DBObject copyParent,
IDPolicy idPolicy)
|
boolean |
equals(java.lang.Object obj)
|
protected boolean |
equalsImpl(CaseStatement other)
|
SQLFragment |
getElseExpression()
|
SQLFragment |
getExpression()
|
protected void |
getOwnedObjectsImpl(java.util.Collection<DBObject> objs,
java.lang.String... types)
Used by all the final children methods. |
java.lang.String |
getSQLText()
Return the SQL for this fragment. |
CaseStatement.WhenThen[] |
getWhenThens()
|
void |
setElseExpression(SQLFragment exp)
|
void |
setExpression(SQLFragment exp)
|
void |
setWhenThens(CaseStatement.WhenThen[] whenThens)
|
Methods inherited from class oracle.javatools.db.sql.AbstractSQLFragment |
---|
appendToBuffer, argsToString, getTextOrNull, getTextOrNull, getType, setParent, surroundWithBrackets, surroundWithBrackets, toString |
Methods inherited from class oracle.javatools.db.AbstractChildDBObject |
---|
copyToImpl, findParent, getParent |
Methods inherited from class oracle.javatools.db.AbstractDBObject |
---|
changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyToImpl, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getProperties, getProperty, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties, setProperty |
Methods inherited from class java.lang.Object |
---|
clone, finalize, getClass, notify, notifyAll, wait, wait, wait |
Methods inherited from interface oracle.javatools.db.ChildDBObject |
---|
getParent |
Methods inherited from interface oracle.javatools.db.DBObject |
---|
copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, replaceReferenceIDs, setID, setName |
Methods inherited from interface oracle.javatools.util.DynamicPropertySet |
---|
getProperties, getProperty, getProperty, setProperties, setProperty |
Field Detail |
---|
public static final java.lang.String CASE
public static final java.lang.String WHEN
public static final java.lang.String THEN
public static final java.lang.String ELSE
public static final java.lang.String END
Constructor Detail |
---|
public CaseStatement()
public CaseStatement(SQLFragment expression, CaseStatement.WhenThen[] whenThens, SQLFragment elseExpression)
public CaseStatement(SQLFragment expression, CaseStatement.WhenThen[] whenThens)
public CaseStatement(CaseStatement.WhenThen[] whenThens, SQLFragment elseExpression)
public CaseStatement(CaseStatement.WhenThen[] whenThens)
Method Detail |
---|
public SQLFragment getExpression()
public void setExpression(SQLFragment exp)
public CaseStatement.WhenThen[] getWhenThens()
public void setWhenThens(CaseStatement.WhenThen[] whenThens)
public SQLFragment getElseExpression()
public void setElseExpression(SQLFragment exp)
public DBObject copyTo(DBObject target, DBObject copyParent, IDPolicy idPolicy)
AbstractDBObject
This method does not fix internal reference ids on copy. That is done by
the calling DBObject.copyTo(DBObject, IDPolicy)
method.
copyTo
in class AbstractDBObject
DBObject.copyTo(java.lang.Object)
,
DBObject.copyTo(DBObject, boolean)
,
AbstractDBObject.copyToImpl(oracle.javatools.db.AbstractDBObject, oracle.javatools.db.DBObject, oracle.javatools.db.IDPolicy)
protected void copyToImpl(CaseStatement copy, DBObject copyParent, IDPolicy idPolicy)
public boolean equals(java.lang.Object obj)
equals
in class java.lang.Object
protected boolean equalsImpl(CaseStatement other)
protected void getOwnedObjectsImpl(java.util.Collection<DBObject> objs, java.lang.String... types)
AbstractDBObject
includesType
to check the types vararg.
getOwnedObjectsImpl
in class AbstractDBObject
objs
- a Collection of the apppropriate children.types
- a vararg of the type(s) to search forAbstractDBObject.includesType(java.lang.String, java.lang.String...)
public java.lang.String getSQLText()
SQLFragment
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1) E13403-04 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |