Introduction

Welcome to this tutorial on Oracle APEX Development Tools. This tutorial will explore two essential tools: App Builder and SQL Workshop. By familiarizing yourself with these tools, you will gain the confidence to create robust applications using Oracle APEX. Let's dive in and discover how these tools can empower you in your APEX development journey.

App Builder

App builder provides a visual development environment for creating stunning web applications without complex coding.

It has four large icons Create, Import, Dashboard, and Workspace utilities.

Create. Launches the Create Application Wizard. Use the Create Application Wizard to build a complete application containing multiple pages.

Import. Launches the Import Wizard. Use this wizard to import export files from the export repository.

Dashboard. Links to the App Builder Dashboard display metrics about applications in the current workspace.

Workspace Utilities. Use the Workspace Utilities page to access REST Enabled SQL Services, Remote Servers, Application Groups, Web Credentials, Workspace Themes, Export, Oracle APEX Views, Manage Backups, and REST Source Catalog.

SQL Workshop

SQL Workshop offers a comprehensive set of SQL development and administration tools.

SQL Workshop home page features

• Object Browser

• SQL Commands

• SQL Scripts

• Utilities

• RESTful Services

In this tutorial, we will be covering Object and SQL Commands only.

Video Tutorial

References

App Builder User's Guide: https://docs.oracle.com/en/database/oracle/apex/23.1/htmdb/index.html

SQL Workshop Guide:

https://docs.oracle.com/en/database/oracle/apex/23.1/aeutl/index.html