/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 vote293 views1 answer
Add multiple field in table sql
SQL
12 votes288 views5 answers
Sql merge
SQL
1 vote269 views1 answer
Clear screen command in psql
SQL
5 votes274 views2 answers
Oracle show procedures
SQL
0 vote291 views1 answer
Vowels in sql
SQL
0 vote279 views2 answers
Create new table plsql
SQL
1 vote282 views1 answer
Psql lst trigger
SQL
0 vote280 views1 answer
Oracle sql winter time change
SQL
0 vote272 views2 answers
Mysql disable foreign key checks
SQL
21 votes286 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL