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 vote141 views1 answer
Sql check for null and empty string
SQL
18 votes181 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
6 votes159 views2 answers
Join vs union
SQL
1 vote155 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
1 vote152 views3 answers
Mysql disable foreign keys check
SQL
-1 vote207 views1 answer
Minus vs except in sql
SQL
8 votes178 views4 answers
Reset SQL auto increment
SQL
-1 vote147 views1 answer
Mac mysql workbench console
SQL
1 vote111 views1 answer
Ms sql - add one hour to time
SQL
6 votes139 views1 answer
Phpmyadmin reset root password
SQL