SQL*Plus provides access to the Oracle database using the command line to enter SQL, PL/SQL, SQL *Plus and operating system commands.
The SQL*Plus plugin enables Deployment Automation to run SQL scripts during a deployment.
To use the plugin steps, open your process and navigate toDatabase > SQLPlus in the Tools pane.
This plugin has the Run SQLPlus Script step for you to add to your processes.
Run SQLPlus Script step
Use this step to run a SQLPlus script.
Note: We recommend that you use this step when you are running an SQL script to create an Oracle function.
The following table describes the step's properties:
|SQLPlus Executable||The full path to the sqlplus executable, the scripts to be run, or the command to be run, if it is on the path.|
|Username||The username used to run the scripts.|
|Password||The password of the user.|
|Connection ID||The connection ID to be used, for example, localhost:1521/ORCL.|
|SQL Files||A newline-separated list of SQL files to be executed. Order is preserved. Supports the * and ? characters as wildcards.|
|Oracle Home||(Optional) The
For information about SQL*Plus, see the SQL*Plus® User's Guide and Reference.