Table of contents
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