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

3 votes143 views1 answer
Kill mysql processlist in whose time more than 200
SQL
8 votes138 views1 answer
Sql remove leading spaces
SQL
2 votes134 views1 answer
Alter table add multiple columns postgresql
SQL
3 votes132 views4 answers
Mysql decimal
SQL
2 votes125 views1 answer
Sql update alias
SQL
0 vote137 views2 answers
Postgresql gset
SQL
0 vote152 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote163 views1 answer
Sp help text in postgresql
SQL
5 votes128 views4 answers
Describe table postgres
SQL
7 votes150 views2 answers
Where keyword sql
SQL