Term: NUMBER

Definition:
Oracle provides the NUMBER data type to store integers (negative, positive, floating) of up to 38 digits of precision. The NUMBER data type can store numbers in the range of 1.0E-130 to 1.0E126.

Other data types falling under the NUMBER data type family are BINARY_INTEGER, PLS_INTEGER, DOUBLE_PRECISION, and FLOAT.

Example Syntax:

NUMBER(x,y)

DECLARE

L_NUM NUMBER;

BEGIN

...

END;

• Oracle Datatypes: NUMBER
• Analytic Functions: Examples using NUMBER
• Array Processing: Examples using NUMBER
• CAST: Examples using NUMBER
• Constraints: Examples using NUMBER
• Conditions: Examples using NUMBER
• Oracle Conversion Functions: Examples using NUMBER
• Decode Case: Examples using NUMBER

• Number Functions: Calculate ratio between X and Y columns - This block calculates the ratio betwee...
• Number Functions: Absolute value - Returns the positive value of a number.
• Number Functions: CIEL - Calculates the smallest integer not less than the argument.
• Number Functions: Radians to degrees - Converts radians to degrees
• Number Functions: Radians - Converts degrees to radians.
• Number Functions: Round to integer - Returns nearest integer to argument.
• Number Functions: Round to n - Rounds to n decimal places
• Number Functions: Truncate - truncate toward zero
• Number Functions: Truncate to n - truncate to n decimal places
• Number Functions: Random - Returns a random number between 0.0 and 1.0
• Function For Number Handling - This 'AndNotNum' Function is intended to check a string or number t...
• Number Functions: Running Average - Returns a running average.
• Number Functions: CORR - Returns the coefficient of correlation of a set of number pairs.
• Number Functions: COUNT (running count) - Returns a running count of all records or by partition.
• Number Functions: COUNT - Returns a frequency distribution.
• Number Functions: RANK - Calculates the rank of a value in a group of values.
• Number Functions: RATIO_TO_REPORT - Computes the ratio of a value to the sum of a set of values. I...
• ROW_NUMBER - Assigns a unique number to each row to which it is applied (either each row in the pa...
• Spell out numbers to words - This handy little script will spell out numbers to words. For example...
• TO_NUMBER - Converts a string to a value of NUMBER datatype. The string can be a BINARY_FLOAT...
• SEQUENCE: Autonumber into two tables - Use a SEQUENCE autonumber and insert into two tables.
• SEQUENCE: Reset a sequence to a predefined number - A small PL/SQL procedure that resets the seque...