This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Used to set up scripts to build/add root certificates to an Oracle Wallet |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This sets up VC |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Origin: https://ora-00001.blogspot.se/2017/03/using-vs-code-for-plsql-development.html | |
// https://gist.github.com/mortenbra/6a10aa6b09fb470e6b91bc3b5adb19af#file-sqlplus_login-sql | |
-- enable compiler warnings | |
alter session set plsql_warnings = 'enable:all'; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Origin: https://ora-00001.blogspot.se/2017/03/using-vs-code-for-plsql-development.html | |
-- https://gist.github.com/mortenbra/3204a125e3da1008e19b36bf94586950#file-vscode_show_errors-sql | |
set pagesize 9999 | |
set linesize 9999 | |
set heading off | |
set trim on | |
select lower(attribute) -- error or warning | |
|| ' ' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/sh | |
# Modified to use sqlcl instead of sqlplus | |
# Origin: https://ora-00001.blogspot.se/2017/03/using-vs-code-for-plsql-development.html | |
# https://gist.github.com/mortenbra/9af4b0211782161619c0bab01ed7031a#file-vscode_run_sqlplus-sh | |
# make sure script uses correct environment settings for sqlplus | |
source ~/.profile | |
SQLPATH=$SQLPATH:.;export SQLPATH | |
# run sqlplus, execute the script, then get the error list and exit |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//Modified to fit the more recent version of VisualCode versions structure for the tasks.json | |
// Origin: https://ora-00001.blogspot.se/2017/03/using-vs-code-for-plsql-development.html | |
// https://gist.github.com/mortenbra/9d7bd2147b02ae8fa2e14dbc38935e5e#file-vscode_tasks-json | |
{ | |
"version": "2.0.0", | |
// The command is a shell script | |
"type": "shell", | |
"group": { | |
"kind": "build", |