3.12.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 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 theapex export
command with the-expWorkspace
option. - Exporting Workspace Static Files
Export a workspace static files using theapex 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.
See Also:
-
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