Oracle 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 vote149 views1 answer
Mysql grant access to one database
SQL
21 votes113 views5 answers
Oracle all tables
SQL
0 vote123 views1 answer
Create query in where clasue
SQL
0 vote139 views1 answer
Login failed for user sql server
SQL
7 votes114 views1 answer
Alter sequence set current value oracle
SQL
2 votes119 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote116 views1 answer
Drop CHECK constraint sql
SQL
1 vote121 views1 answer
Apex select list ORA-20999
SQL
0 vote102 views1 answer
How to print out column name differently in mysql
SQL
0 vote127 views1 answer
How to fetch data from database in sql
SQL