Oracle number to 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

2 votes211 views1 answer
How to show the whole table in sql
SQL
-1 vote224 views1 answer
Phinehas Psalm 106
SQL
2 votes204 views1 answer
Mysql sysdate - 1 day
SQL
0 vote210 views1 answer
Why we have to set the password for my sql server
SQL
0 vote196 views1 answer
Split string by comma in sql server
SQL
0 vote197 views1 answer
SQL get max per id
SQL
2 votes225 views1 answer
Search query in mysql
SQL
0 vote163 views1 answer
Oracle sysdba connect as another user
SQL
5 votes193 views2 answers
Update all rows mysql
SQL
1 vote211 views1 answer
Oracle undo usage per session
SQL