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

3 votes320 views2 answers
Postgres download
SQL
0 vote312 views1 answer
Oracle step procedure
SQL
0 vote312 views1 answer
Mysql wait_timeout
SQL
0 vote336 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
3 votes317 views1 answer
Kill mysql processlist in whose time more than 200
SQL
6 votes298 views1 answer
Oracle desc table primary key
SQL
0 vote295 views1 answer
Mysql workbench not showing schemas
SQL
4 votes327 views1 answer
Data types in sql
SQL
0 vote307 views1 answer
Zerar auto increment mysql
SQL
0 vote311 views1 answer
Subquery aggregation
SQL