Show Changed language Data from DB

Hi All,

It would be great if youcan suggest how to acieve teh belwo in PORATl2 application.

  • I have one column data in english and another column data in Arabic stored in 2 columns in Oracle DB
  • Now once user changes laguage ;let’s say English to Arabic; how I can show Arabic column value instead of English and vice versa in PORATL2

Any help in this well appreciated.

BR,
Bhaski

Sounds like you would need to apply plsql logic to fetch different columns based on the user (stored in a separate table perhaps, if @userid = UserLogin then select arabicColumn else english.. (pseudo code)