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!

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
177 views