DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multi-Lingual Number/Date Format at Runtime?

Zeeshan BaiGJun 16 2008

Hi all,

I am Running Oracle 6i Reports on client server application. i have Multi-Lingual reports running in Russian / English Languages on user parameters.

i want that if user request the report in Russian so it prints all numbers and date in Russian Format and if user request English then it print in English Number date format.
i have one solution for it that i m using currently but it is time consuming Job

i experimented with srw.set_format_mask but it is not working

only solution i have to create Formula columns or separate columns in Query for Russian Language

for Number

to_char(numfield, '999G999G999G999G999D99', 'nls_numeric_characters = '', '''))

to print the 100,000.00 to 100 000,00 format same

with date to_char(dateval,'DD-MON-RRRR', 'nls_date_language = RUSSIAN')

any suggestions?