Difference between revisions of "NUMERIC BUILT IN FUNCTIONS"

From rbachwiki
Jump to navigation Jump to search
 
Line 17: Line 17:
  GREATEST(9,67.6,10)67.6
  GREATEST(9,67.6,10)67.6


<h2> converting numbers to character </h2>
SELECT TO_CHAR(SALARY, '$99,999') AS "SALARY"
FROM EMPLOYEES
RESULT -> $24,000
TO_CHAR(3000, '$999999.99') -> $3000.00
TO_CHAR(4500, '$99,999') -> $4,500
TO_CHAR(9000, '$99,999.99') -> $9,000.00
TO_CHAR(4422, '$0009999') -> $0004422


[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]

Latest revision as of 18:51, 19 November 2017

ROUND()

THE , 2 AT THE END IS NUMBER OF PLACES TO ROUND

ROUND(49.113212,2)  = 49.11

CEIL()

Integer value that is greater than or equal to the number

CEIL(48.99)=49

POWER()

POWER(4,2)=16

SQRT()

SQRT(16)=4

GREATEST()

Returns the largest of multiple value

GREATEST(9,67.6,10)67.6

converting numbers to character

SELECT TO_CHAR(SALARY, '$99,999') AS "SALARY"
FROM EMPLOYEES 
RESULT -> $24,000
TO_CHAR(3000, '$999999.99') -> $3000.00
TO_CHAR(4500, '$99,999') -> $4,500
TO_CHAR(9000, '$99,999.99') -> $9,000.00
TO_CHAR(4422, '$0009999') -> $0004422

Back To Top- Home - Category