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.
oracle.sql.json	The API for JSON type in Oracle Database.

Uses of NUMBER in oracle.jdbc

Methods in oracle.jdbc that return NUMBER
Modifier and Type	Method	Description
`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`	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`	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`	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`	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(boolean 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(double 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(int 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(short value)`	Creates a new NUMBER that has the given value.
`NUMBER`	OracleConnectionWrapper.`createNUMBER(String value, int scale)`	Creates a new NUMBER that has the given value and scale.
`NUMBER`	OracleConnectionWrapper.`createNUMBER(BigDecimal 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`	OracleCallableStatement.`getNUMBER(int parameterIndex)`	Retrieves data into an `oracle.sql.NUMBER` object.
`NUMBER`	OracleResultSet.`getNUMBER(int columnIndex)`	Oracle extension.
`NUMBER`	OracleResultSet.`getNUMBER(String columnName)`	Oracle extension.

Methods in oracle.jdbc with parameters of type NUMBER
Modifier and Type	Method	Description
`void`	OracleCallableStatement.`setNUMBER(String parameterName, NUMBER x)`	Sets the designated parameter to an `oracle.sql.NUMBER`value.
`void`	OraclePreparedStatement.`setNUMBER(int parameterIndex, NUMBER num)`	Binds the designated parameter to a `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(String columnName, NUMBER value)`	Oracle extension.

</section>

Uses of NUMBER in oracle.sql

Methods in oracle.sql that return NUMBER
Modifier and Type	Method	Description
`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.`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.`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.`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.`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`	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.
`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.`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.
`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.`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).
`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.`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.
`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.`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(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.`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.`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.`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.`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.
`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`	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.

Methods in oracle.sql with parameters of type NUMBER
Modifier and Type	Method	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.`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.
`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.`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.
`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.`sub(NUMBER n)`	Returns a new NUMBER object initialized to the difference of NUMBER and n.

</section>

<section role="region">
Uses of NUMBER in oracle.sql.json

Methods in oracle.sql.json that return NUMBER
Modifier and Type Method Description

NUMBER OracleJsonDecimal.getNUMBER()
Returns this binary value as a oracle.sql.NUMBER

</section>

Uses of Class oracle.sql.NUMBER

Uses of NUMBER in oracle.jdbc

Uses of NUMBER in oracle.sql

Uses of NUMBER in oracle.sql.json

Uses of Class
oracle.sql.NUMBER