Package | Description |
---|---|
oracle.jdbc |
Beginning in Oracle9i, the Oracle extensions to JDBC are captured
in the package
oracle.jdbc . |
oracle.sql |
A package of classes that represent java SQL types and Oracle specific
SQL types.
|
Modifier and Type | Method and Description |
---|---|
NUMBER |
OracleConnection.createNUMBER(BigDecimal value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(BigDecimal value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(BigDecimal value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(BigDecimal value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(BigInteger value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(BigInteger value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(BigInteger value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(BigInteger value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(boolean value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(boolean value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(boolean value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(boolean value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(byte value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(byte value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(byte value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(byte value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(double value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(double value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(double value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(double value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(float value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(float value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(float value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(float value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(int value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(int value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(int value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(int value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(long value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(long value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(long value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(long value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(short value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(short value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(short value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(short value)
Creates a new NUMBER that has the given value.
|
NUMBER |
OracleConnection.createNUMBER(String value,
int scale)
Creates a new NUMBER that has the given value and scale.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(String value,
int scale)
Creates a new NUMBER that has the given value and scale.
|
NUMBER |
OracleConnectionWrapper.createNUMBER(String value,
int scale)
Creates a new NUMBER that has the given value and scale.
|
NUMBER |
OracleConnection.createNUMBER(String value,
int scale)
Creates a new NUMBER that has the given value and scale.
|
NUMBER |
OracleCallableStatement.getNUMBER(int parameterIndex)
Retrieves data into an
oracle.sql.NUMBER object. |
NUMBER |
OracleResultSet.getNUMBER(int columnIndex)
Oracle extension.
|
NUMBER |
OracleResultSet.getNUMBER(int columnIndex)
Oracle extension.
|
NUMBER |
OracleCallableStatement.getNUMBER(int parameterIndex)
Retrieves data into an
oracle.sql.NUMBER object. |
NUMBER |
OracleResultSet.getNUMBER(String columnName)
Oracle extension.
|
NUMBER |
OracleResultSet.getNUMBER(String columnName)
Oracle extension.
|
Modifier and Type | Method and Description |
---|---|
void |
OraclePreparedStatement.setNUMBER(int parameterIndex,
NUMBER num)
Binds the designated parameter to a
oracle.sql.NUMBER value. |
void |
OraclePreparedStatement.setNUMBER(int parameterIndex,
NUMBER num)
Binds the designated parameter to a
oracle.sql.NUMBER value. |
void |
OracleCallableStatement.setNUMBER(String parameterName,
NUMBER x)
Sets the designated parameter to an
oracle.sql.NUMBER value. |
void |
OracleCallableStatement.setNUMBER(String parameterName,
NUMBER x)
Sets the designated parameter to an
oracle.sql.NUMBER value. |
void |
OraclePreparedStatement.setNUMBERAtName(String parameterName,
NUMBER value)
Sets the designated parameter to an
oracle.sql.NUMBER value. |
void |
OraclePreparedStatement.setNUMBERAtName(String parameterName,
NUMBER value)
Sets the designated parameter to an
oracle.sql.NUMBER value. |
void |
OracleResultSet.updateNUMBER(int columnIndex,
NUMBER value)
Oracle extension.
|
void |
OracleResultSet.updateNUMBER(int columnIndex,
NUMBER value)
Oracle extension.
|
void |
OracleResultSet.updateNUMBER(String columnName,
NUMBER value)
Oracle extension.
|
void |
OracleResultSet.updateNUMBER(String columnName,
NUMBER value)
Oracle extension.
|
Modifier and Type | Method and Description |
---|---|
NUMBER |
NUMBER.abs()
Returns a new NUMBER object initialized to the absolute value of NUMBER.
|
NUMBER |
NUMBER.abs()
Returns a new NUMBER object initialized to the absolute value of NUMBER.
|
NUMBER |
NUMBER.acos()
Returns a new NUMBER object initialized to the arc cosine value of NUMBER.
|
NUMBER |
NUMBER.acos()
Returns a new NUMBER object initialized to the arc cosine value of NUMBER.
|
NUMBER |
NUMBER.add(NUMBER n)
Returns a new NUMBER object initialized to the value of the addition of
the NUMBER value and n.
|
NUMBER |
NUMBER.add(NUMBER n)
Returns a new NUMBER object initialized to the value of the addition of
the NUMBER value and n.
|
NUMBER |
NUMBER.asin()
Returns a new NUMBER object initialized to the arc sine value of NUMBER.
|
NUMBER |
NUMBER.asin()
Returns a new NUMBER object initialized to the arc sine value of NUMBER.
|
NUMBER |
NUMBER.atan()
Returns a new NUMBER object initialized to the arc tangent value of
NUMBER.
|
NUMBER |
NUMBER.atan()
Returns a new NUMBER object initialized to the arc tangent value of
NUMBER.
|
NUMBER |
NUMBER.atan2(NUMBER x)
Returns a new NUMBER object initialized to the value of atan2(NUMBER/x).
|
NUMBER |
NUMBER.atan2(NUMBER x)
Returns a new NUMBER object initialized to the value of atan2(NUMBER/x).
|
NUMBER |
NUMBER.ceil()
Returns a new NUMBER object initialized to the ceiling of NUMBER value.
|
NUMBER |
NUMBER.ceil()
Returns a new NUMBER object initialized to the ceiling of NUMBER value.
|
NUMBER |
NUMBER.cos()
Returns a new NUMBER object initialized to the cosine value of NUMBER.
|
NUMBER |
NUMBER.cos()
Returns a new NUMBER object initialized to the cosine value of NUMBER.
|
NUMBER |
NUMBER.cosh()
Returns a new NUMBER object initialized to the hyperbolic cosine value
of NUMBER.
|
NUMBER |
NUMBER.cosh()
Returns a new NUMBER object initialized to the hyperbolic cosine value
of NUMBER.
|
NUMBER |
NUMBER.decrement()
Returns a new NUMBER object initialized to the NUMBER value decremented
by 1.
|
NUMBER |
NUMBER.decrement()
Returns a new NUMBER object initialized to the NUMBER value decremented
by 1.
|
NUMBER |
DATE.diffInMonths(DATE date)
Calculates the difference between two dates in months.
|
NUMBER |
DATE.diffInMonths(DATE date)
Calculates the difference between two dates in months.
|
NUMBER |
NUMBER.div(NUMBER n)
Returns a new NUMBER object initialized to the division of NUMBER value
by n.
|
NUMBER |
NUMBER.div(NUMBER n)
Returns a new NUMBER object initialized to the division of NUMBER value
by n.
|
static NUMBER |
NUMBER.e()
Returns a new NUMBER object initialized to the value of e.
|
static NUMBER |
NUMBER.e()
Returns a new NUMBER object initialized to the value of e.
|
NUMBER |
NUMBER.exp()
Returns a new NUMBER object initialized to the value of e raised to
NUMBER value.
|
NUMBER |
NUMBER.exp()
Returns a new NUMBER object initialized to the value of e raised to
NUMBER value.
|
NUMBER |
NUMBER.floatingPointRound(int precision)
Returns a new NUMBER object initialized to Number rounded to precision
significant decimal digits.
|
NUMBER |
NUMBER.floatingPointRound(int precision)
Returns a new NUMBER object initialized to Number rounded to precision
significant decimal digits.
|
NUMBER |
NUMBER.floor()
Returns a new NUMBER object initialized to the floor of NUMBER value.
|
NUMBER |
NUMBER.floor()
Returns a new NUMBER object initialized to the floor of NUMBER value.
|
static NUMBER |
NUMBER.formattedTextToNumber(String num,
String fmt,
String lang)
Returns a NUMBER converted from Num controlled by the format fmt.
|
static NUMBER |
NUMBER.formattedTextToNumber(String num,
String fmt,
String lang)
Returns a NUMBER converted from Num controlled by the format fmt.
|
NUMBER |
NUMBER.increment()
Returns a new NUMBER object initialized to the NUMBER value incremented
by 1.
|
NUMBER |
NUMBER.increment()
Returns a new NUMBER object initialized to the NUMBER value incremented
by 1.
|
NUMBER |
NUMBER.ln()
Returns a new NUMBER object initialized to the natural logarithm of the
NUMBER value.
|
NUMBER |
NUMBER.ln()
Returns a new NUMBER object initialized to the natural logarithm of the
NUMBER value.
|
static NUMBER |
NUMBER.ln10()
Returns a new NUMBER object initialized to the value of ln(10).
|
static NUMBER |
NUMBER.ln10()
Returns a new NUMBER object initialized to the value of ln(10).
|
NUMBER |
NUMBER.log(NUMBER base)
Returns a new NUMBER object initialized to the logarithm to the base
base of the NUMBER value.
|
NUMBER |
NUMBER.log(NUMBER base)
Returns a new NUMBER object initialized to the logarithm to the base
base of the NUMBER value.
|
NUMBER |
NUMBER.mod(NUMBER n)
Returns a new NUMBER object initialized to the remainder of the division
of NUMBER/n.
|
NUMBER |
NUMBER.mod(NUMBER n)
Returns a new NUMBER object initialized to the remainder of the division
of NUMBER/n.
|
NUMBER |
NUMBER.mul(NUMBER n)
Returns a new NUMBER object initialized to product of NUMBER and n.
|
NUMBER |
NUMBER.mul(NUMBER n)
Returns a new NUMBER object initialized to product of NUMBER and n.
|
NUMBER |
NUMBER.negate()
Returns a new NUMBER object initialized to the negated NUMBER value.
|
NUMBER |
NUMBER.negate()
Returns a new NUMBER object initialized to the negated NUMBER value.
|
static NUMBER |
NUMBER.negInf()
Returns a new NUMBER object initialized to negative infinity.
|
static NUMBER |
NUMBER.negInf()
Returns a new NUMBER object initialized to negative infinity.
|
static NUMBER |
NUMBER.pi()
Returns a new NUMBER object initialized to the value of pi.
|
static NUMBER |
NUMBER.pi()
Returns a new NUMBER object initialized to the value of pi.
|
static NUMBER |
NUMBER.posInf()
Returns a new NUMBER object initialized to positive infinity.
|
static NUMBER |
NUMBER.posInf()
Returns a new NUMBER object initialized to positive infinity.
|
NUMBER |
NUMBER.pow(int exp)
Returns a new NUMBER object initialized to NUMBER value raised to the
exp power.
|
NUMBER |
NUMBER.pow(int exp)
Returns a new NUMBER object initialized to NUMBER value raised to the
exp power.
|
NUMBER |
NUMBER.pow(NUMBER exp)
Returns a new NUMBER object initialized to the value of NUMBER value
raised to the exp power.
|
NUMBER |
NUMBER.pow(NUMBER exp)
Returns a new NUMBER object initialized to the value of NUMBER value
raised to the exp power.
|
NUMBER |
NUMBER.round(int decimal_place)
Returns a new NUMBER object initialized to the NUMBER value rounded to
specified decimal place decimal_place.
|
NUMBER |
NUMBER.round(int decimal_place)
Returns a new NUMBER object initialized to the NUMBER value rounded to
specified decimal place decimal_place.
|
NUMBER |
NUMBER.scale(int left,
int right,
boolean[] big)
Returns a new NUMBER object initialized to the value determined by the
rounding performed based on the right parameter below.
|
NUMBER |
NUMBER.scale(int left,
int right,
boolean[] big)
Returns a new NUMBER object initialized to the value determined by the
rounding performed based on the right parameter below.
|
NUMBER |
NUMBER.shift(int digits)
Returns a new NUMBER object initialized the NUMBER value shifted digits
decimal places.
|
NUMBER |
NUMBER.shift(int digits)
Returns a new NUMBER object initialized the NUMBER value shifted digits
decimal places.
|
NUMBER |
NUMBER.sin()
Returns a new NUMBER object initialized to the sine of the NUMBER.
|
NUMBER |
NUMBER.sin()
Returns a new NUMBER object initialized to the sine of the NUMBER.
|
NUMBER |
NUMBER.sinh()
Returns a new NUMBER object initialized to the hyperbolic sine of NUMBER.
|
NUMBER |
NUMBER.sinh()
Returns a new NUMBER object initialized to the hyperbolic sine of NUMBER.
|
NUMBER |
NUMBER.sqroot()
Returns a new NUMBER object initialized to the square root of NUMBER.
|
NUMBER |
NUMBER.sqroot()
Returns a new NUMBER object initialized to the square root of NUMBER.
|
NUMBER |
NUMBER.sub(NUMBER n)
Returns a new NUMBER object initialized to the difference of NUMBER and n.
|
NUMBER |
NUMBER.sub(NUMBER n)
Returns a new NUMBER object initialized to the difference of NUMBER and n.
|
NUMBER |
NUMBER.tan()
Returns a new NUMBER object initialized to the tangent of NUMBER.
|
NUMBER |
NUMBER.tan()
Returns a new NUMBER object initialized to the tangent of NUMBER.
|
NUMBER |
NUMBER.tanh()
Returns a new NUMBER object initialized to the hyperbolic tangent of
Number.
|
NUMBER |
NUMBER.tanh()
Returns a new NUMBER object initialized to the hyperbolic tangent of
Number.
|
static NUMBER |
NUMBER.textToPrecisionNumber(String num,
boolean precflag,
int preclen,
boolean scaleflag,
int scalelen,
String lang)
Returns a NUMBER object initialized to the value in num as described
below.
|
static NUMBER |
NUMBER.textToPrecisionNumber(String num,
boolean precflag,
int preclen,
boolean scaleflag,
int scalelen,
String lang)
Returns a NUMBER object initialized to the value in num as described
below.
|
NUMBER |
DATE.toNumber()
Converts date to an Oracle Number.
|
NUMBER |
DATE.toNumber()
Converts date to an Oracle Number.
|
NUMBER |
NUMBER.truncate(int decimal_place)
Returns a new NUMBER object initialized to the NUMBER value truncated to
specified decimal place decimal_place.
|
NUMBER |
NUMBER.truncate(int decimal_place)
Returns a new NUMBER object initialized to the NUMBER value truncated to
specified decimal place decimal_place.
|
static NUMBER |
NUMBER.zero()
Returns a new NUMBER object initialized to zero.
|
static NUMBER |
NUMBER.zero()
Returns a new NUMBER object initialized to zero.
|
Modifier and Type | Method and Description |
---|---|
NUMBER |
NUMBER.add(NUMBER n)
Returns a new NUMBER object initialized to the value of the addition of
the NUMBER value and n.
|
NUMBER |
NUMBER.add(NUMBER n)
Returns a new NUMBER object initialized to the value of the addition of
the NUMBER value and n.
|
NUMBER |
NUMBER.atan2(NUMBER x)
Returns a new NUMBER object initialized to the value of atan2(NUMBER/x).
|
NUMBER |
NUMBER.atan2(NUMBER x)
Returns a new NUMBER object initialized to the value of atan2(NUMBER/x).
|
int |
NUMBER.compareTo(NUMBER n)
Returns -1 if NUMBER is less than n, 0 if NUMBER and n are equal (==),
1 if NUMBER is greater than n.
|
int |
NUMBER.compareTo(NUMBER n)
Returns -1 if NUMBER is less than n, 0 if NUMBER and n are equal (==),
1 if NUMBER is greater than n.
|
NUMBER |
NUMBER.div(NUMBER n)
Returns a new NUMBER object initialized to the division of NUMBER value
by n.
|
NUMBER |
NUMBER.div(NUMBER n)
Returns a new NUMBER object initialized to the division of NUMBER value
by n.
|
NUMBER |
NUMBER.log(NUMBER base)
Returns a new NUMBER object initialized to the logarithm to the base
base of the NUMBER value.
|
NUMBER |
NUMBER.log(NUMBER base)
Returns a new NUMBER object initialized to the logarithm to the base
base of the NUMBER value.
|
NUMBER |
NUMBER.mod(NUMBER n)
Returns a new NUMBER object initialized to the remainder of the division
of NUMBER/n.
|
NUMBER |
NUMBER.mod(NUMBER n)
Returns a new NUMBER object initialized to the remainder of the division
of NUMBER/n.
|
NUMBER |
NUMBER.mul(NUMBER n)
Returns a new NUMBER object initialized to product of NUMBER and n.
|
NUMBER |
NUMBER.mul(NUMBER n)
Returns a new NUMBER object initialized to product of NUMBER and n.
|
static void |
DATE.numberToJulianDays(NUMBER num,
int[] julianDay,
int[] julianSec)
Converts an Oracle NUMBER to Julian days and seconds
|
static void |
DATE.numberToJulianDays(NUMBER num,
int[] julianDay,
int[] julianSec)
Converts an Oracle NUMBER to Julian days and seconds
|
NUMBER |
NUMBER.pow(NUMBER exp)
Returns a new NUMBER object initialized to the value of NUMBER value
raised to the exp power.
|
NUMBER |
NUMBER.pow(NUMBER exp)
Returns a new NUMBER object initialized to the value of NUMBER value
raised to the exp power.
|
NUMBER |
NUMBER.sub(NUMBER n)
Returns a new NUMBER object initialized to the difference of NUMBER and n.
|
NUMBER |
NUMBER.sub(NUMBER n)
Returns a new NUMBER object initialized to the difference of NUMBER and n.
|