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

7 votes146 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
2 votes144 views1 answer
Set column to not null mysql
SQL
0 vote128 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote140 views1 answer
Mysql start of today
SQL
1 vote147 views1 answer
How to drop function in sql
SQL
0 vote180 views1 answer
Google sheets data validation custom formula filter
SQL
1 vote151 views2 answers
Snowflake alter column data type
SQL
0 vote175 views1 answer
How to check database engine in mysql
SQL
2 votes155 views2 answers
Create empty table from existing table
SQL
3 votes149 views2 answers
Mysql HAVING
SQL