/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 vote180 views1 answer
Mysql value ends with
SQL
1 vote169 views1 answer
Quit mysql
SQL
0 vote163 views1 answer
Ver usuarios mysql
SQL
0 vote185 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
8 votes151 views2 answers
Mysql get first x characters
SQL
0 vote124 views1 answer
Postgres delete where id in
SQL
2 votes208 views2 answers
Mysql date range
SQL
3 votes180 views2 answers
How to force truncate a table in mysql
SQL
0 vote175 views3 answers
Run sql command line
SQL
0 vote172 views1 answer
Sql character index
SQL