/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

5 votes366 views3 answers
Sql limit offset
SQL
0 vote335 views1 answer
Sql server rtrim everything after character
SQL
1 vote316 views1 answer
Sample clause in sql
SQL
3 votes310 views1 answer
Ssh check mysql version
SQL
0 vote325 views1 answer
Plpgsql raise notice
SQL
5 votes344 views4 answers
Mysql update column with value from another table
SQL
0 vote313 views1 answer
Sql server manager close connection
SQL
0 vote337 views3 answers
Run sql command line
SQL
0 vote304 views1 answer
Google cloud sql postgres url example
SQL
0 vote310 views2 answers
Oracle create chain rule
SQL