Creating a New .SQL or .PLSQL File

  • In Oracle Explorer, right click on a existing connection node and select Open New SQL File. If a connection does not exist, create a new one by pressing the plus (+) icon and using the steps in Connecting to Oracle Database or Connecting to Oracle Autonomous Database (ADB).

  • Alternately, Press F1 to open Command Palette and select Oracle:Develop New SQL or PLSQL from the dropdown. Select an existing connection profile from the list or create a new one

  • When done editing, in the VS Code menu select File->Save As to save the file.

  • Alternately, you may execute the SQL*Plus CONNECT command. This command will associate the file with the connection specified in the command.