Exploring Oracle APEX Development Tools
App Builder and SQL Workshop
I am an experienced IT professional with over 10 years of expertise in ERP, specializing in manufacturing and finance modules.
As a solution architect, I am skilled in Oracle PL/SQL and Oracle APEX, with experience in software development, project management, and solution architecture.
Leveraging my expertise in Enterprise Performance Management (EPM), I help businesses make data-driven decisions and improve their performance.
I am committed to staying current with the latest trends and technologies in the industry and enjoy collaborating with colleagues and clients to design and implement solutions that align with their unique business needs.
If you would like to learn more about my experience or have any questions, please feel free to connect with me.
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
