1. Getting Started with Oracle Developer Tools for VS Code
  2. Getting Started with Oracle Developer Tools for VS Code
  3. Saving PL/SQL in Database to a File

Saving PL/SQL in Database to a File

  • In Oracle Database Explorer you can right click a package, procedure, function, or trigger and from the menu and select Download/Download Package Body/Download Package Specification.

  • To change the default directory where the file is saved, go to the settings and change Download: Folder Type to Other Folder. Then, change the setting Download:Other Folder to the path to the folder you wish downloads to be saved in.

  • Alternatively, after opening the package, procedure, function, or trigger from Database Explorer select the tab with the PL/SQL code in it. In Visual Studio Code menu select File->Save As and then click Show Local.

Parent topic: Getting Started with Oracle Developer Tools for VS Code