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 vote213 views1 answer
Uncheck constraints and delete from table
SQL
1 vote230 views1 answer
Oracle plan hash value
SQL
0 vote196 views1 answer
SQL loop with cursor
SQL
6 votes209 views3 answers
Oracle all dates between two dates
SQL
0 vote201 views1 answer
Mysql trim characters
SQL
0 vote249 views2 answers
Php convert dbf to mysql
SQL
3 votes193 views3 answers
Concatenation in sql
SQL
0 vote194 views1 answer
Sql remove last x char
SQL
0 vote223 views1 answer
How to alter length character varying postgres
SQL
1 vote209 views3 answers
Drop unique key constraint in sql server
SQL