Previous Next JavaScript must be enabled to correctly display this content

## 3.11.11.1 Exporting and Importing Using SQLcl

Export workspaces, applications, and related files from a command line using Oracle SQL Developer Command Line (SQLcl) release 22.1 and later.

SQLcl is a free Java-based command-line interface for Oracle AI Database. Use SQLcl to execute SQL and PL/SQL statements interactively or as as a batch file. SQLcl provides inline editing, statement completion, command recall, and also supports existing SQL*Plus scripts.

- Downloading and Installing SQLcl
  Download and install Oracle SQL Developer Command Line (SQLcl) for free.
- Starting SQLcl and Connecting to the Database
  Learn how to start SQLcl and connect to the database.
- Exiting SQLcl
  Learn how to exit SQLcl.
- Listing Applications
  Use SQLcl to list all or selected APEX applications in a workspace.
- Listing Components in an Application
  Use SQLcl to list all or selected components in an APEX application.
- Exporting One or More Applications
  Use SQLcl to export a single APEX application or all applications in a workspace.
- Exporting a Workspace
  Export a workspace using the `apex export` command with the `-expWorkspace` option.
- Exporting Workspace Static Files
  Export a workspace static files using the `apex export` command and `-expFiles` option.
- Installing an Application
  Install an APEX application into a target environment by running a SQL script.
- Importing a Workspace
  Import an APEX workspace into a target environment.
- Importing Workspace Static Files
  Import APEX workspace static files into a target environment.
- Synchronizing Feedback Among Environments
  Learn about best practices for synchronizing feedback from development, test, and production environments.
- Displaying Application Usage
  View a summary of APEX application usage.

Related Topics

- Working with SQLcl in Oracle SQLcl User’s Guide
- Deploying an Application in Oracle APEX App Builder User’s Guide

Parent topic: Exporting and Importing from a Command Line