I think it's a very fundamental question and yet, I didn't find anything about that topic on the net:
I have a lot of different feature-types defined in an Oracle DB and several attributes of this feature (i.e. construction_type) are set via codelists. Meaning in the feature-table there is a column construction_type_cl_id, in the codelist itself there is the corresponding id and a text-value for the construction_type.
I should transform this schema into another one, without this codelists.
My question now: How can I check for certain ids in the codelists, get the corresponding string, and then based on that string search for another id in a different codelist for to reclassify the features?
Thanks in advance for any input!
Regards
Markus
