Query data on table with lower case object name fails

I have a table in my schema with a object name in lowercase "schema_version" (created by the Flyway db migration tool).

When I right click and select query data the query is pasted in a new sql window without quotes:

select * from APPL_KLANTCONTACT.schema_version t

And I get a ORA-00942: table or view does not exist error.
Now I have to manually add the quotes to make it work.
Is it possible to always add quotes for this kind of objects?
 
Applies to version 11.0.5.1790, 64 bit.

Unfortunately, PLD does not handle lower/mixed case objects very successfully.

Must be (yet another) candidate for a major overhaul.
 
Exactly.
Could you add support for lowercase objects/object attributes names?
It does not work properly almost everywhere in PSD, eg. when drag 'n drop object/attribute names from object browser or describe window, in code assistant (missing "" over object type names, inproper case in code assistant object list), in sql window when select with object types etc.
 
Last edited:
Back
Top