Skip navigation links
oracle.javatools.db.sql
Class CaseStatement
java.lang.Object
oracle.javatools.db.AbstractDBObject
oracle.javatools.db.AbstractChildDBObject
oracle.javatools.db.sql.AbstractSQLFragment
oracle.javatools.db.sql.CaseStatement
- All Implemented Interfaces:
- ChildDBObject, DBObject, SQLFragment, Copyable, DynamicPropertySet
-
public class CaseStatement
- extends AbstractSQLFragment
Class to represent a case statement in a sql query.
CASE [expression]
WHEN condition THEN thenExpression
WHEN condition THEN thenExpression ...
[ELSE elseExpression]
END
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 interface oracle.javatools.db.sql.SQLFragment |
CONNECTBY, FROM, GROUPBY, HAVING, MODEL, NOCYCLE, ORDERBY, ORDERSIBLINGSBY, PRIOR, SELECT, STARTWITH, TYPE, WHERE |
Methods inherited from class oracle.javatools.db.sql.AbstractSQLFragment |
appendToBuffer, argsToString, getStartOffset, getTextOrNull, getTextOrNull, getType, setParent, setStartOffset, surroundWithBrackets, surroundWithBrackets, toString |
Methods inherited from class oracle.javatools.db.AbstractDBObject |
changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getProperties, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties |
Methods inherited from class java.lang.Object |
clone, finalize, getClass, notify, notifyAll, wait, wait, wait |
Methods inherited from interface oracle.javatools.db.DBObject |
copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, replaceReferenceIDs, setID, setName |
CASE
public static final java.lang.String CASE
-
- See Also:
- Constant Field Values
WHEN
public static final java.lang.String WHEN
-
- See Also:
- Constant Field Values
THEN
public static final java.lang.String THEN
-
- See Also:
- Constant Field Values
ELSE
public static final java.lang.String ELSE
-
- See Also:
- Constant Field Values
END
public static final java.lang.String END
-
- See Also:
- Constant Field Values
CaseStatement
public CaseStatement()
CaseStatement
public CaseStatement(SQLFragment expression,
CaseStatement.WhenThen[] whenThens,
SQLFragment elseExpression)
- CASE expression WHEN condition THEN thenExpression ... ELSE elseExpression END
CaseStatement
public CaseStatement(SQLFragment expression,
CaseStatement.WhenThen[] whenThens)
- CASE expression WHEN condition THEN thenExpression ... END
CaseStatement
public CaseStatement(CaseStatement.WhenThen[] whenThens,
SQLFragment elseExpression)
- CASE WHEN condition THEN thenExpression ... ELSE elseExpression END
CaseStatement
public CaseStatement(CaseStatement.WhenThen[] whenThens)
- CASE WHEN condition THEN thenExpression ... END
getExpression
public SQLFragment getExpression()
setExpression
public void setExpression(SQLFragment expression)
getWhenThens
public CaseStatement.WhenThen[] getWhenThens()
setWhenThens
public void setWhenThens(CaseStatement.WhenThen[] whenThens)
getElseExpression
public SQLFragment getElseExpression()
setElseExpression
public void setElseExpression(SQLFragment elseExpression)
getSQLText
public java.lang.String getSQLText()
- Description copied from interface:
SQLFragment
- 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.
Skip navigation links
Copyright © 1997, 2012, Oracle. All rights reserved.