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

2 votes209 views1 answer
Coalesce sql
SQL
0 vote205 views1 answer
Sql values that contains certain multiple ids
SQL
2 votes171 views1 answer
Get hour from date sql
SQL
0 vote163 views1 answer
SQL authentication error
SQL
0 vote151 views1 answer
Get number of table colums in sql query
SQL
-1 vote166 views1 answer
Mysql select all columns and specific fields as
SQL
1 vote177 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
6 votes184 views3 answers
Mysql create database utf8
SQL
1 vote177 views1 answer
Alter constraint in sql
SQL
0 vote182 views1 answer
Php select data from mysql database without column name
SQL