Setting up SQLcl in Antigravity
locally installed
May 14, 20263 min read
Command Palette
Search for a command to run...
Latest articles
En preparación para APEX 26: SQL Developer en VS Code y Antigravity.
La nueva versión de APEX incluye una característica que va a cambiar drásticamente la forma en que trabajamos actualmente: APEXLang Hablamos de un nuevo formato basado en archivos que contrasta con la
May 11, 20264 min read
Create files Chunks and vectors from APEX
This is a process you could do using OCI features, but if you’d like to manage files from an APEX application, take care of the conversion to vectors and store them your database, it’s quite possible and not that complicated. What for? let’s say we w...
Oct 15, 20253 min read
"Function Body returning SQL Query" with multiple queries.
Here are a couple of things to consider when creating a report using a Function Body that returns an SQL Query as the data source and using "IF" to decide which query will be executed. "ELSE" must be present. The query in the "ELSE" condition will ...
Apr 26, 20242 min read
Avoid Malicious JavaScript in Lists
Recently I was asked to review and test an APEX application to fulfill the security team requirements before we can publish it, making an emphasis in escaping special characters. In General, APEX takes care of this. If you see the attributes of an Pa...
Jan 19, 20242 min read
Comparing text in Interactive Report Columns (Template Component Plugin)
Early this year, someone asked me for a way to compare the text selected from two columns of a report and show de differences highlighted in colors. I looked for the easiest way to accomplish this requirement and found a cool library to do it, htmdif...
Oct 11, 20232 min read
3 Things to consider when upgrading APEX to 23.1
Commonly, applications continue working as expected after installing a new version of APEX (thankfully) but sometimes, and often depending on the APEX version you're currently working on, your applications may be impacted, even if compatibility mode ...
Sep 23, 20232 min read