/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

1 vote329 views1 answer
Mysql count multiple columns in one query
SQL
0 vote311 views1 answer
Suse start MySQL
SQL
0 vote404 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote375 views1 answer
Oracle insert single quote in string
SQL
0 vote325 views2 answers
Get all index postgres
SQL
8 votes360 views2 answers
Mysql get first x characters
SQL
0 vote343 views1 answer
Mysql terminal run sql file
SQL
17 votes344 views2 answers
Mysql date to string
SQL
0 vote397 views1 answer
Mssql last day of month
SQL
0 vote306 views1 answer
Linux upload database to mysql
SQL