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

11 votes210 views2 answers
Oracle saurce code
SQL
0 vote372 views1 answer
Install mysql on bash
SQL
7 votes189 views1 answer
Sql server convert string to date
SQL
1 vote190 views2 answers
Mysql type conversion
SQL
4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
20 votes213 views5 answers
Reset auto increment mysql
SQL
10 votes218 views2 answers
Select nextval from sequence oracle
SQL
0 vote198 views1 answer
Oracle array
SQL
0 vote239 views1 answer
Joomla execute raw sql
SQL
3 votes180 views1 answer
Sql timestamp to date
SQL