Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Feb 17, 2025SQLcl Projects ReferenceThis is a Quick Reference / Cheat Sheet take your pick. SQLcl Projects is a feature in Oracle's SQLcl tool that helps manage and automate database changes and deployments for Oracle Database and APEX applications. It provides a structured approach to...6 likes·239 readssqlcl
Sydney Nursesynuora.hashnode.dev·Feb 12, 2025ORDS: Using URI Patterns to protect ResourcesCreating and publishing RESTful APIs from the database is pretty common and fairly simple with Oracle REST Data Services (ORDS). In most cases those exposed APIs would be protected with an API Gateway or the built-in protection of ORDS. If you are un...66 readsorclapex
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Feb 10, 2025Find an APEX Component ID in all Oracle APEX Dictionary ViewsOK Pretty niche, but if you ever want to find which columns in which views an APEX Component ID resides in, here’s a brute force approach for you: DECLARE l_id NUMBER := 7128208610686091; -- Change to your component ID l_sql VARCHAR2(4000); ...4 likes·171 readsorclapex
Jon Dixonblog.cloudnueva.com·Feb 6, 2025Consolidating Validation Logic with APEX_ERRORIntroduction There are many options for handling validations in Oracle APEX. This post will focus on the PL/SQL Error validation type. I want to focus on this validation type because it allows us to consolidate validation logic into a PL/SQL package,...8 likes·609 readsorclapex
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Feb 3, 2025Using AI to generate Oracle APEX Theme Roller Styles v.2I’ve previously blogged on this subject, however I found that as new versions of the Universal Theme appeared, it meant that that approach no longer worked. Here is an approach that is hopefully future proof. It works on APEX 24.2 at least. NOTE: I a...2 likes·521 readsorclapex
Anton Nielsenapexdebug.com·Jan 31, 2025Mark This DownYou may have heard me say it before, but I like writing documentation. That includes both help text within an application and the comments describing how to use APIs. I don’t, however, like writing documentation that never gets read. Or worse still, ...2 likes·248 readsOracle
Jon Dixonblog.cloudnueva.com·Jan 31, 2025Automatically Re-Enable APEX Automations After DeploymentIntroduction As you may know, when you deploy an APEX Application, APEX automatically disables all of the APEX Automations associated with that Application. This is perfectly fine in many scenarios, but when deploying to production, you nearly always...10 likes·537 readsorclapex
Plamen Mushkovblog.apexapplab.dev·Jan 31, 2025Streamline Your Development Workflow: Bitbucket and Jira Integration GuideWhy is it a good idea? In the world of software development, managing code changes and tracking project progress are two important aspects of the whole process. To improve the visibility and traceability of all changes, and most importantly see which...48 readsci-cd
Scott Spendolinispendolini.blog·Jan 28, 2025Exploring a SaaS API PlatformIf you followed my last post, you should have integrated Jira Cloud & APEX so that you can see projects, issues and comments from the APEX side. As you may have inferred, building that application did take some time, most of which was spent on learni...2 likes·304 readsAPEX & Jira: Exploring REST Data SourcesPostman
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Jan 27, 2025APEX 24.2 RAG Search with apex_ai - Search your Database RecordsIn this blog, We are going Vectorize our EMP table by creating embeddings. We’re going to perform a Vector Search for ‘Who is the President?’ When the record comes back we’ll use Generative AI with the same question to give a natural language resp...8 likes·419 readsorclapex