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

10 votes331 views5 answers
Between keyword in sql
SQL
0 vote303 views2 answers
Sql select inside select
SQL
19 votes353 views6 answers
Mysql if null
SQL
0 vote317 views1 answer
Compare if is null sql
SQL
22 votes366 views4 answers
Date format mysql
SQL
7 votes303 views4 answers
How to reset the identity column in sql server
SQL
0 vote313 views1 answer
Json not contains mysql
SQL
0 vote333 views1 answer
Sql get count without group by
SQL
2 votes370 views1 answer
Creating a view SQL
SQL
1 vote381 views1 answer
How to set up a trigger in sql
SQL