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

3 votes118 views1 answer
Delete all content in table mysql
SQL
7 votes137 views2 answers
How to create index mysql
SQL
2 votes132 views1 answer
Mysql shell insert into
SQL
6 votes136 views2 answers
Mysqldump password in file
SQL
3 votes118 views1 answer
Sql multiple column index
SQL
0 vote112 views1 answer
Mysql create pool
SQL
0 vote125 views1 answer
Oracle sql alter view add column
SQL
2 votes118 views1 answer
Install sqlite npm
SQL
0 vote114 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote154 views2 answers
Mysql cast to varchar
SQL