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 votes358 views3 answers
Postgresql reset auto increment
SQL
9 votes370 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote366 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote380 views1 answer
Where name ends in SQL
SQL
0 vote376 views3 answers
Database restoring error
SQL
0 vote341 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote354 views1 answer
If exist column in table drop sql query mysql
SQL
1 vote413 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote362 views1 answer
Oracle sql date winter time
SQL
1 vote365 views4 answers
Aggregate function in sql
SQL