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	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.

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.

Uses of Classoracle.sql.NUMBER

Uses of NUMBER in oracle.jdbc

Uses of NUMBER in oracle.sql

Uses of Class
oracle.sql.NUMBER