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 vote353 views1 answer
Mysql persistence.xml
SQL
0 vote368 views1 answer
How to make full text search dynamic in mysql
SQL
2 votes386 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote365 views1 answer
Example database query
SQL
0 vote395 views1 answer
CONVERT time string into 12 hours in sql
SQL
2 votes367 views4 answers
2nd highest salary in mysql
SQL
1 vote343 views1 answer
Create procedure with encryption
SQL
1 vote383 views1 answer
Sql where max date
SQL
36 votes368 views3 answers
Finding duplicate column values in table with sql
SQL
6 votes341 views2 answers
WHERE value IS sql
SQL