The SQLcl plugin provides the capability to execute SQL scripts in Oracle databases using SQLcl.

Key Features

• Easily configurable.

• Saves query results and outputs to files (spool file) for reporting and documentation.

• Supports the @file syntax for execution.

• Compatible with Oracle databases.

• Fixes common syntax issues before executing the SQL file.

Plugin Operations

• packageBuild(SQLcl)

• packageDeploy(SQLcl)

• runScript(SQLcl)

• compileInvalidSqls(SQlcl)

Supported Object Types

SQLcl Plugin supports package-based deployment, see below for details on supported object types. These links explain the two types and their attributes.

Object Types

1. DB Objects

2. Other Objects