/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 vote177 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote178 views1 answer
Automate mysql cli query
SQL
1 vote140 views1 answer
Postgres division by zero
SQL
0 vote199 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
1 vote259 views1 answer
Sql select contem uma palavra
SQL
0 vote208 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
-1 vote194 views5 answers
Online sql to linq generator
SQL
0 vote186 views1 answer
Add colum date in sql
SQL
2 votes315 views2 answers
MySql FULL OUTER JOIN
SQL
6 votes185 views2 answers
Oracle
SQL