Mixed Case and Export User Objects

[mofleybk]

Using Mixed Case (miXedCase) names in your Oracle objects causes a few fits for PL/SQL Developer. If you are working on a project converted from either MS Access or MS SQL Server, you most often get double quoted mixed case object names.

PL/SQL Developer cannot edit these objects...you have to manually add double quotes to your object names to edit data, etc.

I love PL/SQL developer and prefer it to Oracles SQL Developer. While they do have a beta version that handles mixed case quite well, I prefer the PL/SQL Dev environment. I especially love the schema export from "Export User Objects" in PL/SQL Dev as it does an awesome job of ordering the output. The built in right-click DBMS_Metadata-->DDL works great for mixed case, but doesn't allow for mass export in the proper order.

Any word on when a version of PL/SQL Developer will be available that support mixed case through and through?

Thanks.

 

[Marco Kalter]

This is on the list of enhancement requests. I do not have a concrete date yet though.

 

[mofleybk]

Greetings,

I just downloaded and tested the new beta version 8 of PL/SQL Developer and it does not appear to solve the mixedCase issue.

Is there a menu/preferences setting that will allow PL/SQL Developer 8 to work with mixedCase table and field names?

Thanks

 

[Marco Kalter]

I don't have a concrete date yet, but it's on the to-do list.