Run Oracle Database Scripts
Executes Oracle database scripts using sqlplus commandline tool.
Task can run multiple database scripts during a release.
How it works
Task will look for .sql files in a specified directory to run sqlplus against a database. Options can be added to the sql file to enhance functionality of the script.
Sqlplus.exe must be available before running this task.
Run Pester test located under "Tests" folder to verify sqlplus is installed.
If using self-hosted pipelines, a user-defined capability may have to be added to each build server (sqlplus.exe).