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 vote271 views1 answer
Mysql Digital Ocean connection problems
SQL
-3 votes257 views1 answer
Remove spaces sql 2008
SQL
5 votes258 views4 answers
Describe table postgres
SQL
1 vote270 views1 answer
Oracle apex prevent initial load
SQL
0 vote318 views1 answer
Generate sql from specific migration ef core
SQL
0 vote270 views1 answer
Postgresql find missing id
SQL
0 vote272 views1 answer
Sql show all users
SQL
0 vote286 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote276 views1 answer
Pgsql is not permitted to log in
SQL
0 vote285 views1 answer
Postgres list all stored procedures query
SQL