/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 vote181 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote174 views1 answer
How to connect pgadmin with excel
SQL
0 vote185 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote284 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote211 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote175 views1 answer
Sql gather statistics to increase performance
SQL
1 vote179 views3 answers
How to truncate foreign key constraint table
SQL
4 votes198 views3 answers
Count with where
SQL
0 vote189 views1 answer
Mysql vs sql server performance benchmark
SQL
10 votes181 views2 answers
Tsql merge example
SQL