/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 vote257 views1 answer
Oracle list of long running queries
SQL
1 vote249 views1 answer
Oracle aleter trigger ora-01031
SQL
1 vote273 views1 answer
Sql string function update replace
SQL
0 vote285 views1 answer
Sql quary intervewi question
SQL
0 vote244 views1 answer
How to check if there is no database schema
SQL
10 votes260 views5 answers
Mysql create user
SQL
0 vote263 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
2 votes260 views3 answers
Oracle show column of table
SQL
1 vote294 views2 answers
Drop table with constraints
SQL
12 votes261 views4 answers
Mysql ifnull
SQL