/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 vote122 views1 answer
Psql check table fields
SQL
0 vote110 views1 answer
ALV GRID events
SQL
11 votes97 views1 answer
Oracle view ddl
SQL
0 vote240 views2 answers
Mysql insert rows to another database
SQL
2 votes113 views1 answer
Oracle kill session by sql_id
SQL
3 votes110 views3 answers
Stop mysql service ubuntu
SQL
1 vote184 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote101 views1 answer
Sql common columns
SQL
1 vote102 views1 answer
Regular expression in sql server
SQL
0 vote173 views1 answer
How to get number of months between 2 dates sql server
SQL