/SQL/Oracle to_char number format percentage

Oracle to_char number format percentage

-- Formatted
SELECT decimal_column * 100 || '%' AS percentage FROM table_name;
-- Rounded
SELECT round(decimal_column * 100, 2) || '%' AS percentage FROM table_name;
-- Value
SELECT decimal_column * 100 AS percentage FROM table_name;
SELECT TO_CHAR(decimal_column,'fm990D00','NLS_NUMERIC_CHARACTERS = ''.,''') 
	FROM dual;

Similar codes

3 votes97 views2 answers
To_char oracle
SQL
13 votes91 views2 answers
Check if value is null mysql
SQL
0 vote219 views1 answer
Sql server query all database objects
SQL
-1 vote92 views1 answer
Round up and down sql
SQL
3 votes106 views1 answer
Oracle drop user
SQL
0 vote97 views1 answer
Last date for each user sql
SQL
0 vote114 views1 answer
Oracle show grants on table
SQL
15 votes107 views3 answers
Mysql update add to existing value
SQL
0 vote107 views1 answer
Oracle session statistics
SQL
0 vote118 views2 answers
Unique key
SQL