"Code Insight pick list" does not work properly with case sensitive column names.
To reproduce the problem follow the steps below:
1.Create table with the script below:
CREATE TABLE TEMP ("Case sensitive" VARCHAR2(10));
2. Go to the editor and type
SELECT T.
FROM TEMP T
The pick list returns:
SELECT T.CASE SENSITIVE
FROM TEMP T
This query fails with error:
ORA-00904: "T"."CASE": invalid identifier
The correct select is
SELECT T."Case sensitive"
FROM TEMP T
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center