Does PL/SQL Developer (8.0.4) support quoted identifiers/case sensitive object names like "MySchema"."MyTable"."Column01"?
I need this feature especially in Tools->Export User Objects.
There are some restriction when using mixed case identifiers. I'm not sure how this applies specifically to the 8.0.4 export tool. Are you experiencing any problems?
Yes, unfortunately there are several problems.
Only the column names and in the 'create table' statement are encapsulated correctly in double quotation marks.
They are missing generally in schema names and object names and they are missing in column names in key constraints.

Current output:
create table myschema.myobject ("MyColumnName" VARCHAR2(10));
alter table myschema.myobject add constraint fk_MyColumnName foreign key (MyColumnName) references myschema.myobject2(MyColumnName);

Expected output:
create table "MySchema"."MyObject" ("MyColumnName" VARCHAR2(10));
alter table "MySchema"."MyObject" add constraint "fk_MyColumnName" foreign key ("MyColumnName") references "MySchema"."MyObject2"("MyColumnName");

Is that problem fixed in 9.x ?

Regards
Frank

Any news?
An other problem concerning case sensitive object names:
If you drag an object with a mixed case name from the Objects Browser into an editor or SQL window, the names are not encapsulated in double quotation marks.

Current naming: mytab1.mycol1
Expected naming: "MyTab1"."MyCol1"

If that problem is fixed in 9.x, I could convince my IT department to purchase the new version.

Regards
Frank
© Allround Automations forums