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 vote288 views2 answers
CREATE OR REPLACE FUNCTION
SQL
1 vote318 views1 answer
Alter database datafile maxsize 32g
SQL
1 vote298 views1 answer
Oracle nvl2
SQL
0 vote266 views1 answer
Redirection 301 htaccess nom de domaine
SQL
1 vote273 views1 answer
Install postgresql on raspberry pi
SQL
6 votes271 views2 answers
Drop foreign key
SQL
0 vote282 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote308 views1 answer
Insert value in identity
SQL
0 vote296 views3 answers
How to run sql query
SQL
0 vote286 views1 answer
Mysql multiple group by
SQL