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 votes337 views1 answer
Mysql virtual column
SQL
0 vote341 views1 answer
Tsql pad left
SQL
0 vote334 views1 answer
Get foreign table names mysql
SQL
31 votes325 views3 answers
Sql count(*)
SQL
0 vote330 views1 answer
Sql select with apostrohpe
SQL
0 vote320 views1 answer
Sql get table last modified time
SQL
11 votes314 views2 answers
Having keyword sql
SQL
12 votes326 views4 answers
Install mysql ubuntu 18.04
SQL
53 votes539 views6 answers
Sql server alter column
SQL
1 vote379 views1 answer
Oracle see column type
SQL