Formatting report column in currency in Oracle
Here is the little script to convert number to char and trailing with $ symbol. select new_cost, to_char( old_cost,'$999,99,999') as original_cost from cpt_products; It displays result like – 12227 $6,000…