/SQL/Oracle to_char number format percentage

Oracle to_char number format 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 vote149 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote140 views1 answer
Basic structure of sql expression having clause
SQL
0 vote131 views1 answer
Automate mysql cli query
SQL
2 votes137 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote141 views1 answer
Mysql date time string format python
SQL
1 vote160 views1 answer
Sql order by timestamp
SQL
0 vote150 views3 answers
Run sql command line
SQL
8 votes155 views1 answer
Mac restore mysql database command line
SQL
1 vote115 views1 answer
Oracle compile schema
SQL
0 vote145 views1 answer
Replace content value from old to new sql
SQL