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 vote153 views1 answer
Sql query to force the database to be drop
SQL
0 vote157 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote148 views1 answer
Set column in all row mysql
SQL
1 vote154 views1 answer
Mysql backup skip table
SQL
4 votes262 views1 answer
What are the data types
SQL
4 votes146 views2 answers
How to delete row in sql
SQL
1 vote153 views2 answers
Sql where keyword
SQL
0 vote143 views1 answer
Hw to delete a procedure in pl sql
SQL
1 vote158 views1 answer
How to unlock table in mysql
SQL
0 vote171 views1 answer
Min varias colunas spark sql
SQL