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 vote213 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote226 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote211 views1 answer
Hive batch drop table
SQL
2 votes191 views1 answer
Sql select in list
SQL
0 vote225 views1 answer
Json not contains mysql
SQL
0 vote229 views1 answer
Select last N rows mysql
SQL
0 vote244 views1 answer
Sql change primary key to composite key
SQL
0 vote235 views1 answer
Sql developer search all packages for text
SQL
1 vote240 views2 answers
Sql server add time to date
SQL
0 vote209 views2 answers
Sql select inside select
SQL