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

0 vote335 views1 answer
T-sql check if data exists
SQL
6 votes367 views1 answer
Identify primary key in oracle table
SQL
0 vote375 views1 answer
Min:sec datediff mssql
SQL
0 vote331 views4 answers
Mysql replace regex
SQL
0 vote348 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote342 views3 answers
Get free card roblox
SQL
0 vote347 views1 answer
Initcap in sql
SQL
0 vote348 views1 answer
Install squirrel sql ubuntu
SQL
-1 vote337 views1 answer
Sql add column bit
SQL
5 votes362 views1 answer
Dbms_metadata.get_ddl table
SQL