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

0 vote271 views1 answer
Sql declare variable single line
SQL
5 votes197 views1 answer
How to check nls format in oracle
SQL
1 vote212 views1 answer
Sql current timestamp
SQL
0 vote221 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote203 views1 answer
How to check replication lag in mySQL
SQL
0 vote210 views1 answer
Postgresql inline table
SQL
0 vote275 views1 answer
How to add auto increment primary key
SQL
10 votes212 views6 answers
Between sql
SQL
3 votes192 views1 answer
Oracle transaction commit rollback example
SQL
1 vote215 views1 answer
Tsql get beginning of year
SQL