/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

3 votes296 views1 answer
Oracle transaction commit rollback example
SQL
1 vote276 views1 answer
Sql delete row with auto increment
SQL
0 vote279 views1 answer
Php select data from mysql database without column name
SQL
0 vote276 views1 answer
Sql clear table
SQL
0 vote217 views1 answer
How to get last client id sql
SQL
6 votes280 views2 answers
How to copy data in sql
SQL
1 vote274 views2 answers
Sql example query
SQL
0 vote228 views1 answer
Mysql offset from bottom
SQL
-1 vote267 views1 answer
Sql syntax create timestamp column
SQL
2 votes305 views1 answer
Mysql shell insert into
SQL