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

14 votes148 views3 answers
Oracle sql limit results
SQL
1 vote160 views1 answer
Mysql view current queries
SQL
3 votes93 views1 answer
System.debug apex
SQL
8 votes141 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
19 votes159 views6 answers
Create table sqlite
SQL
1 vote124 views1 answer
Customer using hdfc bank sql query
SQL
0 vote147 views1 answer
Default column value in sql same as another column laravel
SQL
1 vote184 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
3 votes157 views1 answer
Set default today mysql
SQL
4 votes127 views1 answer
Add constraint fk
SQL