Print Thread
quoted identifiers/case sensitive object names
#47126 05/26/13 11:21 AM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
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.

Re: quoted identifiers/case sensitive object names
FrankMUC #47132 05/27/13 08:36 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
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?


Marco Kalter
Allround Automations
Re: quoted identifiers/case sensitive object names
Marco Kalter #47186 06/04/13 05:03 PM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
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


Re: quoted identifiers/case sensitive object names
FrankMUC #47481 07/18/13 03:18 PM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
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


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.057s Queries: 15 (0.010s) Memory: 2.5098 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-04 16:47:12 UTC
Valid HTML 5 and Valid CSS