Hello, I'm new to PL/SQL and APEX.
I want to create dynamic select list in tabular form based on another column in the same tabular form. But it keep telling me missing expression.
Can somebody tell me whats wrong with my code?
Here's , my code
SELECT ID, NILAI,
APEX_ITEM.SELECT_LIST_FROM_QUERY(7,NILAI,'SELECT V.MEANING AS DISPLAY,
LOOKUP_CODE AS RETURN_V FROM apps.fnd_lookup_types_vl@SUCODEV T,
apps.fnd_lookup_values_vl@SUCODEV V where T.lookup_type = V.lookup_type and v.attribute_category =' ||'SCI_TYPE_SELEKSI'|| 'and V.ATTRIBUTE1 =' ||SELEKSI||) SELECT_LIST_NILAI
FROM SCI_TABLE
v.attribute_category is category from lookup in database
I want to make this select list dynamic as V.ATTRIBUTE1 value is generated by another column named SELEKSI
I'm sorry for poor explanation
I just edited my display name to Lexover XD
Thank you
Message was edited by: Lexover
Message was edited by: Lexover