/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

2 votes174 views1 answer
Import large .sql files into lampp
SQL
3 votes195 views1 answer
Create a table with an id in mysql
SQL
4 votes179 views3 answers
Drop Table Oracle
SQL
16 votes179 views3 answers
Tsql rename column name
SQL
0 vote181 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
-2 votes212 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote176 views1 answer
Left join in codeigniter query builder
SQL
1 vote179 views1 answer
Oracle add proxy
SQL
1 vote179 views1 answer
Python clean sql string
SQL
0 vote180 views1 answer
Alasql delete column
SQL