Oracle number to 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

3 votes307 views1 answer
Search for column name in psql
SQL
0 vote344 views1 answer
Postgres get database encoding
SQL
0 vote287 views1 answer
Mysql does collate nopad recognize space
SQL
-1 vote331 views1 answer
How to dump .csv file into mysql
SQL
0 vote336 views1 answer
Helptext in sql
SQL
9 votes339 views4 answers
Oracle get table column names
SQL
0 vote328 views1 answer
Oracle step procedure
SQL
2 votes364 views1 answer
Where clause for child record apex
SQL
19 votes347 views3 answers
How to change column type psql
SQL
5 votes327 views3 answers
Sql max value in column
SQL