Oracle provides an extension for Visual Studio Code (VS Code) to enable Oracle users to write and execute Oracle SQL statements directly in VS Code. Extensions are pre-packaged functionality, often provided by third parties, which add new features and functionality to VS Code.
Installing Oracle Developer Tools for VS Code
To install Oracle Developer Tools for VS Code:
Upgrade Visual Studio Code to version 1.67.0 or later. You can check the version by using the Help->About menu item. To upgrade select Help->Check for Updates.
Click on the Extensions icon in the Activity Bar on the side of VS Code or use the View: Show Extensions command (Ctrl+Shift+X)
Type Oracle in the extension search bar
Locate Oracle Developer Tools for VS Code and click Install
When the installation is complete, restart Visual Studio Code
Source
Oracle Developer Tools for VS Code (SQL and PLSQL) - Visual Studio Marketplace