Hi!
APEX 20.1 and ORDS 20.2 and Database 19.3
I am trying to build an application to support bilingual (and maybe multilingual) descriptions. I am starting with Lookup Tables like Address_Type and Salutation Type and Unit Of Measures. I have a View to define the Lookup Tables with Instead of Triggers on Insert/Delete/Update.
Is there an Example available for doing this?
My Idea of the layout is
Table_Code
Table Description in Primary Language (as picked from the User Desktop Environment)
Table Description in the Other Language
Flag Active
Date Start
Date End
The View has columns
LOOKUP_SK
VALUE_SK
TABLE_TYPE_CODE
INTERFACE_TYPE_CODE
TABLE_TYPE_DESC
FLAG_ACTIVE
DATE_START
DATE_END