Oracle number to 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 vote226 views1 answer
Normalization in database 2nd normal form
SQL
17 votes221 views6 answers
Sql select distinct
SQL
5 votes223 views2 answers
Mysql import gzip db
SQL
2 votes246 views1 answer
How to select from mssql
SQL
2 votes247 views1 answer
Oracle run_duration to number
SQL
0 vote220 views1 answer
Coalesce for comma separated in sql server
SQL
6 votes224 views2 answers
Non relational database
SQL
4 votes217 views1 answer
Force drop all tables postgres
SQL
2 votes226 views3 answers
Copy data from one table column to another table column in sql
SQL
18 votes223 views6 answers
Creating table in MySQL
SQL