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 vote148 views3 answers
How to verify sequence result in oracle SQL
SQL
2 votes159 views1 answer
Q operator in oracle
SQL
5 votes177 views4 answers
SQL Order of execution
SQL
1 vote157 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
10 votes292 views4 answers
Mysql if else
SQL
0 vote156 views1 answer
Dump db only triggers mysql
SQL
0 vote169 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote172 views1 answer
Mysqlimport
SQL
0 vote158 views4 answers
Postgresql between month
SQL
2 votes184 views3 answers
Row number mssql
SQL