Thursday, April 6, 2017

OIM: Lookup Query

SELECT LKU.LKU_TYPE_STRING_KEY AS "Lookup Name", LKV.LKV_ENCODED AS "Code Key", LKV.LKV_DECODED AS "Decode Key" from LKV, LKU 
WHERE lower(LKU.LKU_TYPE_STRING_KEY) like '<your_lookup_name_in_lower_case>' and 
LKV.lku_key = LKU.lku_key 

order by LKU.LKU_TYPE_STRING_KEY;

No comments:

Post a Comment