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 vote150 views1 answer
Creating a simple notify in postgresql
SQL
0 vote131 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote134 views1 answer
Sql show all users
SQL
0 vote144 views1 answer
Jdbc sql connection string
SQL
0 vote167 views1 answer
How to find unique element in sql
SQL
0 vote147 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
14 votes138 views4 answers
Sql compiler
SQL
0 vote143 views1 answer
Storing RGBA in mysql db
SQL
0 vote146 views1 answer
Default value false mysql
SQL
0 vote144 views1 answer
Oracle synonym procedure dblink
SQL