7.2 Commands Overview

This section describes the SQLcl APEX commands that support APEXlang. For detailed information about each command, see APEXlang in the SQLcl Command Reference chapter.

Command	Description
generate	Creates starter APEXlang project files.
export	Exports an existing APEX application as APEXlang source.
validate	Compiles and validates APEXlang source files.
import	Compiles and imports APEXlang source into the database.

generate

The generate command creates starter application files that can be used as a foundation for development. These templates can be compiled and imported into APEX, and are intended to be customized by the user.

When a database connection is present, SQLcl determines the appropriate version automatically.

export

The export command supports APEXlang as an export type, allowing existing APEX applications to be converted into APEXlang code. This command converts an Oracle APEX application into APEXlang source files in .apx format.

validate

The validate command compiles APEXlang input and reports any errors. If no issues are found, a success message is displayed.

Supported inputs include a directory, zip file, or a single APEXlang file containing the entire application.

The APEXlang compiler is used to compile APEXlang source files as part of the validate and import operations.

import

The import command compiles APEXlang input and executes the resulting PL/SQL using the current database connection.

Compilation errors are reported with file name, line, column, and message details. If successful, the application is created or updated.

Supported inputs include a directory, zip file, or a single APEXlang file containing the entire application.