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.
0