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 vote199 views1 answer
Sql get guid
SQL
28 votes159 views6 answers
Distinct sql
SQL
-1 vote221 views2 answers
Import data from excel to sql server automatically
SQL
3 votes205 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote191 views1 answer
Declaring variables in pl sql
SQL
2 votes196 views1 answer
Select from array in psql
SQL
11 votes206 views2 answers
Set default column value sql
SQL
0 vote215 views1 answer
Mysql set variable to today's date
SQL
16 votes244 views1 answer
Sqlserver add column to table
SQL
1 vote220 views1 answer
Add many column to sap iq table
SQL