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

4 votes220 views2 answers
Mysql show indexes on table
SQL
2 votes211 views2 answers
Mysql date range
SQL
0 vote217 views1 answer
Oracle list of long running queries
SQL
0 vote255 views1 answer
Sql show founctions
SQL
0 vote205 views1 answer
Sql offfset
SQL
0 vote206 views1 answer
Connect postgresql using a connection string
SQL
6 votes226 views3 answers
Commit in sql
SQL
0 vote213 views1 answer
Sql remove non numeric characters
SQL
1 vote223 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
3 votes212 views2 answers
WhereIn SQL
SQL