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 vote195 views1 answer
Get last updated row sql server
SQL
0 vote188 views1 answer
Max mysql
SQL
1 vote212 views1 answer
Sql server loop over query
SQL
0 vote187 views1 answer
Code to move ietms from one table to another myswl
SQL
6 votes210 views2 answers
Mysql 1 day ago
SQL
1 vote248 views1 answer
Mysql sort by date column
SQL
1 vote170 views2 answers
Mysql type conversion
SQL
0 vote180 views1 answer
Sql case sttement with set
SQL
0 vote181 views1 answer
Postgres where
SQL
0 vote167 views2 answers
Mysql slave status
SQL