Query Language Translation Tables
I am attempting to query a table that has to foreign keys (i.e. VendorID and ProductID). In the related tables, there is a localizationID that corresponds to a longtext value in the language translation tables. So the longtext of the vendorname and the longtext of the productname is stored in the language translation table, due to this RDBS being an international application. I need to pass the values to separate variables to create a column for the vendorname and productname. I am joining on the VendorID and ProductID to the related tables to obtain the localizationID for both. Any thoughts would be appreciated.
Subject
Written By
Posted
Query Language Translation Tables
April 29, 2017 09:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.