Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values Sources

Summary:

SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values Sources


Content (required):

I have entered below SQL on the Query box for a user defined LOV query under Manage List Of Values Sources:

SELECT ROWNUM AS LOV_ID, COLUMN1 FROM (SELECT 'Header' COLUMN1 FROM DUAL

UNION 

SELECT 'Line' COLUMN1 FROM DUAL)


But once saved, the query automatically changed to uppercase as below:

SELECT ROWNUM AS LOV_ID, COLUMN1 FROM (SELECT 'HEADER' COLUMN1 FROM DUAL

UNION 

SELECT 'LINE' COLUMN1 FROM DUAL)


I need case sensitive data on my job while selecting the parameter and on the output.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!