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 vote125 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
14 votes134 views1 answer
Sql value of string
SQL
0 vote129 views1 answer
Sql server alter table column nullable
SQL
0 vote215 views1 answer
Which MySQL data type to use for storing boolean values
SQL
2 votes121 views1 answer
Oracle cpu per session
SQL
2 votes127 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote213 views1 answer
Drop check command
SQL
8 votes147 views1 answer
Database backup in mysql server recovery
SQL
10 votes124 views6 answers
Mysql delete duplicates
SQL
0 vote137 views1 answer
Custom row number
SQL