talkapex.comSQLcl 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...Jul 5, 2025·1 min read
talkapex.comTips 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...Jan 22, 2024·4 min read
talkapex.comSQL 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...Jan 22, 2024·3 min read
talkapex.comHow 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> ...Jan 17, 2024·2 min read
talkapex.comWhat 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...Jan 15, 2024·2 min read