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 vote325 views1 answer
Renombrar tabla mysql
SQL
2 votes364 views1 answer
Mysql select true or false
SQL
3 votes312 views1 answer
Sql server check version
SQL
1 vote339 views1 answer
Update foreign key value in mysql
SQL
3 votes299 views2 answers
Having in mysql
SQL
0 vote332 views1 answer
Show the colums of table sql
SQL
1 vote315 views1 answer
How to between in sql
SQL
0 vote350 views2 answers
Insert data mysql with cmd
SQL
0 vote323 views1 answer
Database xml sql
SQL
0 vote307 views1 answer
Get number of tables in database sql
SQL