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

1 vote345 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote425 views1 answer
Mysql get nested records
SQL
1 vote335 views1 answer
Postgres convert date to string
SQL
0 vote340 views2 answers
Collation in sql
SQL
11 votes328 views2 answers
Set default column value sql
SQL
1 vote353 views1 answer
How to delay stored procedure execution in sql server
SQL
6 votes324 views1 answer
Update left join mysql
SQL
0 vote331 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote316 views1 answer
Renommer table sql
SQL
0 vote364 views2 answers
Generate sql trigger through ef migration
SQL