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

0 vote200 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote208 views1 answer
Basic structure of sql expression having clause
SQL
0 vote177 views1 answer
Jdbc sql connection string
SQL
3 votes188 views2 answers
See mysql users ubuntu
SQL
0 vote178 views1 answer
Normalization in database
SQL
0 vote198 views1 answer
How to print sql query
SQL
11 votes208 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
1 vote173 views1 answer
Sql get missing id
SQL
5 votes204 views1 answer
Ascending order and where in sql
SQL
0 vote167 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL