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

16 votes185 views4 answers
Sort by sql
SQL
6 votes184 views1 answer
Phpmyadmin password root
SQL
3 votes256 views1 answer
Apex call duration
SQL
0 vote189 views1 answer
Sql decode
SQL
0 vote172 views1 answer
How to output a different column name in mysql
SQL
0 vote224 views1 answer
Sql query to select even numbers
SQL
3 votes191 views2 answers
Mysql import gz
SQL
15 votes188 views2 answers
Select where duplicate mysql
SQL
0 vote190 views1 answer
Sql server sleep
SQL
1 vote155 views1 answer
Unique vs distinct sql
SQL