Skip to Main Content

SQL Developer for VS Code

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Bug - Duplicate Column Name in Query causes results to shift into the wrong column

Tyson MeyersFeb 14 2024

Example - If there are 3 columns, and column 1 and column 2 have the same name, then vs code is shifting column2's results into column 3.

Please see screen shots. First one from sql developer which adds an _1 to the column, and displays the results in the proper columns. The second screen shot is from vs code. Both use the example query below:

Select 'Column1_Data' Column1, 'Column2_Data' Column1, 'Column3_Data' Column3
From dual;

Comments
Post Details
Added on Feb 14 2024
1 comment
173 views