![pl sql developer run script pl sql developer run script](https://docs.oracle.com/cd/E11882_01/appdev.112/e12511/img/script_editor.gif)
#PL SQL DEVELOPER RUN SCRIPT CODE#
You'll also see squiggly lines under the errors in the code itself, and you can hover over the text to see a tooltip containing the error message. You can click on each problem to jump to the relevant line of code. You can go to a "symbol" (ie a function or procedure) inside a package by pressing Shift+Ctrl+O and typing the name of the symbol: The PL/SQL language extension by xyz provides syntax highlighting for PL/SQL, as well as a couple of very useful code navigation features. Optionally create a login.sql file in project root folder and add:
![pl sql developer run script pl sql developer run script](https://kubadownload.com/site/assets/files/3460/guid-0de519b0-4994-4d09-911e-e2cb068d0d12-default.730x0.gif)
Windows: Copy the following text and save it as _run_sqlplus.bat in the project root folder.
![pl sql developer run script pl sql developer run script](https://oracle-base.com/articles/misc/images/sqldev31-sched/01-DBA-Browser.jpg)
Linux and Mac: Copy the following text and save it as _run_sqlplus.sh in the project root folder (remember to chmod +x the file to make it executable). Your list of extensions should now look something like this:Ĭlick File, Preferences, Color Theme and select the "Blackboard" theme.Ĭlick File, Preferences, File Icon Theme and select the "Material Icon" theme.Ĭonfiguring a Task Runner to compile PL/SQL codeĬlick File, Open Folder and open a folder containing your PL/SQL code.Ĭlick View, Command Palette and enter "task" then select "Configure Task Runner", select "Others".Ĭopy the following text and paste it into the tasks.json file:Īdjust the connection string as appropriate to your environment.Ĭopy the following text and save it as _show_errors.sql in the project root folder:
#PL SQL DEVELOPER RUN SCRIPT INSTALL#
Search for "plsql" and install the "apng.orclapex-autocomplete" extension (added )Ĭlick on "Reload" to restart VS Code with the new extensions loaded.Search for "material icon" and install the "PKief.material-icon-theme" extension.Search for "blackboard" and install the "gerane.Theme-Blackboard" extension.Search for "tag" and install the "to-close-tag" extension.Search for "git lens" and install the "eamodio.gitlens" extension.Search for "better merge" and install the "pprice.better-merge" extension (update : this extension is now part of VS Code itself and does not need to be installed separately).Search for "git history" and install the "donjayamanne.githistory" extension.The following are all optional but recommended: Search for "plsql" and install the "xyz.plsql-language" extension.Start VS Code and click the Extensions icon. Can be adapted to PL/SQL coding via a plsql language extension (syntax highlighting, go to/peek definition, go to symbol) and PL/SQL compilation using sqlplus via a Task Runner (see below for PL/SQL specifics)ĭownload VS Code from and run the installer.