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 vote306 views1 answer
Nosql vs sql
SQL
0 vote320 views1 answer
Mssql + bit + in python orm
SQL
1 vote291 views1 answer
Sql select where id not exists in another table
SQL
5 votes323 views3 answers
Show indexes mysql
SQL
1 vote316 views3 answers
Execute sp in sql server
SQL
1 vote264 views1 answer
Alter user mysql native password
SQL
3 votes266 views1 answer
How to get list of synonyms in oracle
SQL
1 vote258 views1 answer
Strict in postgres SQL
SQL
0 vote292 views1 answer
Bash block size ls /var/lib/mysql
SQL
2 votes310 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL