...
Property Name | Property Code | Required | Description |
---|---|---|---|
SQL Extension Order |
| No | List SQL file extensions in desired order. Will be used for discover and sort. Files with these extensions will discover as type DB Object. |
SQL Retry Count Default |
| No | When discovering or evaluating files, default the Retry Count to this. |
Stop On Deployment Error |
| No | Stop deploying package files if any error occurs. If unchecked all files will be deployed even if one or more files fails. This is for package operations only. |
SQL Ignore Compile Warning Extensions |
| No | When discovering or evaluating files, set the Ignore SQL Compilation Warning attribute to true for files with these extensions. |
SQL Property Replacement Default |
| No | When discovering or evaluating files, default Property Replacement to this. |
SQL Root Target Folder |
| No | The path to store the delivered Sql files. Sql files will be run from here. Leave blank to run them from the |
Other Root Target Folder |
| No | The path to store the delivered Other files. Leave blank to store them in the |
Inputs
Input Name | Input Code | Required | Description |
---|---|---|---|
User Profile (login.sql) |
| No | User Profile (login.sql) is intended to allow users to specifically customize their session. (see the Special considerations section for examples) |
Generate SQL Spool File |
| No | Check to generate report (Spool file) of SQL statement executions. |
Show DBMS Output |
| No | Check to print DBMS output in the log. |
...
Code Block |
---|
-- Set the SQL*Plus environment settings SET ECHO OFF SET FEEDBACK ON SET HEADING ON SET LINESIZE 200 SET PAGESIZE 9999 SET SERVEROUTPUT ON SET TERMOUT ON SET TIMING ON SET VERIFY OFF -- Set default schema ALTER SESSION SET CURRENT_SCHEMA=YOUR_SCHEMA_NAME; -- Define common substitution variables DEFINE my_variable = 'default_value' -- Custom SQL*Plus prompt SET SQLPROMPT "SQL> " -- Display a welcome message PROMPT Welcome to SQL*Plus |
See Please see below for information about the project file attributes.
Supported Object Types
The SQL*Plus plugin partial deploy support allows for deploying File and Folder type objects. These links explain the three types and their attributes.
...