MGMartin Giffy D'Souzaintalkapex.com·Jul 5, 2025 · 1 min readSQLcl host CommandOracle SQLcl is the command line tool to connect to an Oracle database. One neat feature it has is the ability to call host commands (i.e call terminal commands directly from SQLcl). You can use any of the following to trigger a host command: host ho...01Z
MGMartin Giffy D'Souzaintalkapex.com·Jan 22, 2024 · 4 min readTips for APEX Application ConstantsIt's very common for APEX application to have application level items (usually these are named APP_... or G_... and are defined in Shared Components > Application Items). For values that are unique to a given user/session application items are a logi...04PRJOO
MGMartin Giffy D'Souzaintalkapex.com·Jan 22, 2024 · 3 min readSQL Developer for VS CodeLast week SQL Developer for VS Code was released (direct link to VS Code extension here). If you're not using VS Code (VSC) I highly suggest you download and install as it's the de facto editor for developers (regardless of programming language). I'v...01S
MGMartin Giffy D'Souzaintalkapex.com·Jan 17, 2024 · 2 min readHow to Generate a sitemap.xml in SQLI recently had to generate a sitemap.xml for an public facing APEX application. The official sitemap protocol has the following example: <?xml version="1.0" encoding="UTF-8"?> <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"> <url> ...00
MGMartin Giffy D'Souzaintalkapex.com·Jan 15, 2024 · 2 min readWhat Happens to APEX Page Items that are Never Rendered?Every APEX page item has a Server Side condition which controls whether the item is rendered on the page. They're various server side condition options and for the purpose of this article we'll just set it to Never (can do things like queries that re...00
