NUMERIC BUILT IN FUNCTIONS - Revision history

Bacchas at 18:51, 19 November 2017

2017-11-19T18:51:26Z

← Older revision		Revision as of 18:51, 19 November 2017
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]]

Bacchas at 19:16, 5 November 2017

2017-11-05T19:16:50Z

← Older revision		Revision as of 19:16, 5 November 2017
Line 1:		Line 1:
	==ROUND()==		==ROUND()==
	ROUND(49.113212) = 49.11		''' THE , 2 AT THE END IS NUMBER OF PLACES TO ROUND'''
			ROUND(49.113212,2) = 49.11

	==CEIL()==		==CEIL()==
Line 15:		Line 16:
	''' Returns the largest of multiple value'''		''' Returns the largest of multiple value'''
	GREATEST(9,67.6,10)67.6		GREATEST(9,67.6,10)67.6


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

Bacchas: Created page with "==ROUND()== ROUND(49.113212) = 49.11 ==CEIL()== '''Integer value that is greater than or equal to the number''' CEIL(48.99)=49 ==POWER()== POWER(4,2)=16 ==SQRT()== SQR..."

2017-11-05T19:10:33Z

Created page with "==ROUND()== ROUND(49.113212) = 49.11 ==CEIL()== '''Integer value that is greater than or equal to the number''' CEIL(48.99)=49 ==POWER()== POWER(4,2)=16 ==SQRT()== SQR..."

New page

==ROUND()==
ROUND(49.113212) = 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