Uses of Class oracle.sql.NUMBER (Oracle Database JDBC Java API Reference)

Packages that use NUMBER
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.

Uses of NUMBER in oracle.jdbc

Methods in oracle.jdbc that return NUMBER
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.

Methods in oracle.jdbc with parameters of type NUMBER
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.

Uses of NUMBER in oracle.sql

Methods in oracle.sql that return NUMBER
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.

Methods in oracle.sql with parameters of type NUMBER
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.