/SQL/Oracle to_char number format percentage

Oracle to_char number format 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 vote171 views1 answer
Mysql set variable to today's date
SQL
0 vote165 views2 answers
Mysql updating multiple column values from array variable
SQL
5 votes188 views1 answer
Oracle create table comment
SQL
0 vote176 views1 answer
Is not sql
SQL
0 vote167 views1 answer
Dns slave zone convert
SQL
1 vote167 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote167 views1 answer
Postgres sql alter table delete row
SQL
7 votes175 views3 answers
Python and mysql connectivity
SQL
1 vote168 views2 answers
Group_concat limit mysql
SQL
8 votes188 views1 answer
Alter tablespace add datafile autoextend
SQL