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

1 vote139 views1 answer
Sql random sampling per group
SQL
0 vote138 views1 answer
Mysql custom sort order
SQL
-1 vote124 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
1 vote118 views1 answer
Mysql best tutorial for beginners
SQL
0 vote127 views1 answer
Bidirectional outer join sql
SQL
1 vote125 views1 answer
Moodle query first user access
SQL
10 votes125 views3 answers
Insert into auto increment mysql
SQL
1 vote132 views1 answer
Get create table query existing table mysql
SQL
1 vote125 views1 answer
Group_concat order by
SQL
0 vote117 views1 answer
Mysql money value
SQL