/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 vote189 views1 answer
INSERT INTO table using OpenQuery
SQL
9 votes202 views2 answers
Get first 3 letters in sql
SQL
5 votes186 views1 answer
Update sql user password
SQL
0 vote217 views1 answer
Différence entre deux dates sql oracle
SQL
2 votes190 views2 answers
Mysql get time from datetime
SQL
0 vote205 views1 answer
Sql select by content lenght
SQL
3 votes286 views1 answer
Apex call duration
SQL
0 vote166 views1 answer
How to check oracle index table
SQL
0 vote279 views1 answer
How to check common records in 2 table
SQL
0 vote219 views1 answer
Mysql config address
SQL