Number Formatting : Numeric Formatting « Data Type « Oracle PL / SQL

1. Oracle PL / SQL
2. Data Type
3. Numeric Formatting

Number Formatting

 
 
Character       Example       Explanation          
9               9999          Each character represents a place holder for digits.    
0               999.00        Used for leading or trailing zeros.         
$               $9999         prefixes the number with a dollar sign.         
S               S9999         Useful for positive and negative numbers in query results.         
PR              9999PR        Displays negative numbers in angle brackets.         
D or .          99D99, 99.99  Places a decimal point in the place where the D or. is.         
,               9,999         Places a comma in the place where the , is.         
RN or rn        RN            Displays roman numerals, in upper-or lowercase depending on the case of the format mask.         
DATE            date          Assumes the number in a Julian date, and displays the resulting value in MM/DD/YY format.       

 

Related examples in the same category