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

1 vote331 views1 answer
Flask sqlalchemy default value
SQL
1 vote336 views1 answer
Oracle turn off constraint
SQL
3 votes340 views4 answers
Order by desc postgres
SQL
0 vote373 views1 answer
Mysql create index lost connection
SQL
0 vote327 views1 answer
Function sum(text) does not exist postgres
SQL
1 vote543 views3 answers
Sql subquery
SQL
-1 vote333 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote331 views1 answer
Set open file limit mac catalina mysql
SQL
5 votes382 views2 answers
Add days in oracle sql
SQL
0 vote326 views1 answer
How to select even id in sql
SQL