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

9 votes134 views3 answers
Mysql show table column full description
SQL
0 vote127 views1 answer
Sql random decimal
SQL
0 vote137 views1 answer
Flask sqlalchemy decimal
SQL
0 vote148 views1 answer
Rollback to name in sql
SQL
0 vote133 views1 answer
Sql datediff db2
SQL
1 vote133 views1 answer
Mysql how to reset primary key
SQL
0 vote135 views1 answer
Sql roll up rows into columns
SQL
0 vote130 views1 answer
Nth max in my sql
SQL
0 vote180 views1 answer
Oracle sqlp update amount / quantity
SQL
5 votes94 views1 answer
Copy table from one database to another mysql
SQL