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

5 votes276 views2 answers
Postgre insert select
SQL
0 vote258 views1 answer
Check if a word appears at the end sql query
SQL
0 vote297 views1 answer
Sql select column name like from multiple tables
SQL
-2 votes299 views1 answer
How-to-remove-mysql-root-password
SQL
6 votes264 views1 answer
How to count number of rows in sql
SQL
1 vote320 views1 answer
Default
SQL
5 votes300 views1 answer
Purge undo tablespace usage
SQL
36 votes304 views3 answers
Add column in mysq
SQL
1 vote327 views2 answers
Laravel jwt generate token
SQL
0 vote251 views0 answer
SQL