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.

Table View - Insert Rows

Daniel FoxDec 19 2024

When adding rows manually to a table in Legacy SQL Developer, the output that pops up has the values that were used so we can copy and paste into our migration scripts for simplicity.

INSERT INTO DB.TABLE_NAME (FIELD1,FIELD2) VALUES ('VALUE 1' ,2);

In the new VS Code Extension, the same process yields a parameter insert statement instead of the one with values.

INSERT INTO DB.TABLE_NAME (FIELD1, FIELD2) VALUES (:1, :2);

Is there a setting that we can change or that can be added to mimic the behavior of the legacy tool?

Comments
Post Details
Added on Dec 19 2024
5 comments
140 views