/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 vote150 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
2 votes144 views1 answer
No data found oracle
SQL
11 votes210 views5 answers
Update table from another table mysql
SQL
0 vote143 views1 answer
Mysql filter based on datediff
SQL
4 votes133 views2 answers
Insert current date in mysql
SQL
1 vote129 views1 answer
Join first name and last name sql
SQL
3 votes138 views3 answers
Sql last week
SQL
0 vote134 views1 answer
Mysql add to value
SQL
8 votes172 views1 answer
Insert a select statement into a table
SQL
0 vote147 views1 answer
Get the First and Last Word from a String or Sentence
SQL