/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 vote145 views1 answer
Gcloud sql list databases
SQL
1 vote132 views1 answer
Sql string function update replace
SQL
0 vote133 views1 answer
Restore backup mysql .gz
SQL
1 vote134 views3 answers
Default password of mysql
SQL
0 vote137 views1 answer
How to select even id in sql
SQL
4 votes128 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote156 views1 answer
Mysql last friday of current month
SQL
0 vote135 views1 answer
Create table in dbms cmds
SQL
5 votes162 views4 answers
Sql check
SQL
4 votes142 views2 answers
What is table in sql
SQL