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 vote258 views1 answer
How to find unique key in sql
SQL
10 votes265 views4 answers
Inner join in update query mysql
SQL
0 vote277 views1 answer
Can we rollback in sql
SQL
1 vote270 views1 answer
What is int in mysql
SQL
3 votes280 views2 answers
Search text in all sql server stored procedure
SQL
10 votes304 views6 answers
Mysql set root password
SQL
0 vote259 views1 answer
Equi joins in oracle
SQL
0 vote267 views1 answer
Procedures sql insert mysql
SQL
0 vote262 views1 answer
Add colum date in sql
SQL
2 votes254 views2 answers
Postgres set user as superuser
SQL