I have a varchar2 field that has data like
'100000 out of 400000' , '100 out of 100000' etc. Now i have to format it as '1,00,000 out of 4,00,000' '100 out of 1,00,000' etc. Actually , i am myself creating this text field : ie i have 2 numeric variables that are concatenated with 'out of' to get the text string that is stored in the database. The numeric variables are calculated inside a SP. Any idea how i can achieve this? In the number format methods that i have seen in to_number etc , we have to specify the number of digits before and after a ',' .... and these numbers can range from 1 to a few billions.
. Any ideas?
Regards,
S. Jayaram Uparna .
'100000 out of 400000' , '100 out of 100000' etc. Now i have to format it as '1,00,000 out of 4,00,000' '100 out of 1,00,000' etc. Actually , i am myself creating this text field : ie i have 2 numeric variables that are concatenated with 'out of' to get the text string that is stored in the database. The numeric variables are calculated inside a SP. Any idea how i can achieve this? In the number format methods that i have seen in to_number etc , we have to specify the number of digits before and after a ',' .... and these numbers can range from 1 to a few billions.
. Any ideas?Regards,
S. Jayaram Uparna .