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 …
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 …
Recently I was working on re-modelling and re-designing an oracle database. As part of the re-modelling I was required to import data from old tables to new tables. One of…