Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bug: SQLFORMAT INSERT uses incorrect quoting

KiwiAndrewAug 29 2015 — edited Sep 4 2015

SQL Developer 4.1.0.19 64-bit

When using sqlformat insert, SQL Developer (and sqlcl) will put quotes around the target table name if it's no upper-cased e.g.

set sqlformat insert

select * from dual;

returns

REM INSERTING into dual

SET DEFINE OFF;

Insert into "dual" (DUMMY) values ('X');

which is incorrect since the quotes then make the table-name case-sensitive (yes, I know I can't actually insert into DUAL) and won't match the actual table.

IMHO it would be better to only use the quotes if the original request included them, since otherwise the source table is case-insensitive.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2015
Added on Aug 29 2015
5 comments
868 views