Most of what I write here is about Oracle, APEX, and SQLcl. This one is a little different. I started playing around with Home Assistant at my house and using AI to help me get things connected. That
Building on the previous topic of leveraging Liquibase properties to modify APEX installations, we will delve into a companion technique. This one enables users to define as many property files as they wish in the artifact to set it when deploying. T...
Prereqs Latest SQLcl Existing SQLcl Project with an APEX app Note On average, I prefer to keep the same Schema name, APEX Application ID, Workspace Name, and Workspace ID across environments and h
Situation Recently I was given a seed data file that was generated from SQLcl with a bunch of INSERT statements, and it worked fine in SQL Developer when ran but would fail in SQLcl with the following: SQL> @DEMO_DATA_TABLE.sql Error starting at lin...
There are plenty of good resources explaining how to create custom download links in APEX so I will skip over that part and list a couple here: - https://oracle-base.com/articles/misc/apex-tips-file-download-from-a-button-or-link - https://joelkallma...
Quick Tip for handling the merging of JSON in Oracle Database!
So finally we are using some of APEX 20.2 new features like the cool new Data Synchronization for REST Data Sources. I assume most companies deploy from command line so if you do, here are some pointers we have learned from the process and some work ...
This blog has been sitting idle for too long. So starting off the New Year with a quick find! Here is the problem: We need to loop through all page items to apply some logic on demand, and preferably we want to do it dynamically. Taking a look at a...
APEX 20.1 is now live on apex.oracle.com. I took some time to dig around some features, but one that stuck out right away was the new template options for the login screen. On your login page, go to Template Options: Login Page Appearence Section ...
