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

2 votes341 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
3 votes329 views2 answers
Postgres download
SQL
0 vote313 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
-1 vote299 views2 answers
On delete set default sql server
SQL
0 vote328 views1 answer
Postgresql auto increment not working
SQL
2 votes307 views1 answer
Date_format for time sql
SQL
0 vote304 views1 answer
Enable Rabbitmq management plugin
SQL
-1 vote323 views1 answer
Mysql order by on condition
SQL
0 vote332 views1 answer
Convert excel into sqllite db using python
SQL
34 votes312 views6 answers
Sql change data type
SQL