3.12.6 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.

• 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 installing an APEXlang export or 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.