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

8 votes162 views1 answer
See all users mysql
SQL
0 vote147 views1 answer
Yesql
SQL
0 vote143 views1 answer
Access mysql database docker container shell
SQL
0 vote144 views1 answer
Create table database in psql
SQL
0 vote144 views1 answer
See Foreign Key
SQL
0 vote150 views1 answer
Oracle sql add column auto generated value
SQL
0 vote194 views1 answer
How to compile a function in oracle
SQL
0 vote163 views1 answer
Sql track modification
SQL
0 vote144 views1 answer
Mysql get longest string in column
SQL
1 vote193 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL