Hi,
I have a column name inst_num. it has value 2565565
If i need to convert it into 2,565,565
i use as below:
select to_char(inst_num,'9,999,999') from table_name;
but i don't know what value comes in inst_num in future. for e.g. if value 2565565565565 comes then above code will not work.
I need to convert the format by checking the value on runtime. could any body suggest How i can do same in oracle.