DPDavid Patakiindavidpataki.com·3d ago · 17 min readConnecting Oracle APEX Applications with REST Enabled SQLBased on a 2024 conference talk This article is based on my presentation “Linking All My APEX Together with REST Enabled SQL”, delivered at APEX Alpe Adria on April 12, 2024. It reflects the architect00
LSLuís Santosinlslabsessions.hashnode.dev·Sep 13 · 3 min readUpgrading Oracle APEX on Autonomous Database: What I Observed from 24.2.17 to 26.1.4 Before the Upgrade On 28 July, I received an email informing that Oracle APEX 26.1 had become available for my Autonomous Database instance. I decided to postpone the upgrade because I was taking a co00
RGRafal Grzegorczykinrafal.hashnode.dev·Aug 27 · 3 min readSQLcl has built-in code snippets (ALIAS command). Because you can't remember everything, right?How many times a day do you re-type the exact same SQL queries? Whether it is checking system time, finding out which employees earn way too much, or running a complex query to check active database s00
LDLakshay Dhoundiyalinlakshaydhoundiyal.hashnode.dev·Aug 9 · 8 min readWhy Do Banks Use Oracle Database? The Technology Behind Modern BankingYou open your banking app. You enter ₹10,000. You tap Send. A few seconds later: “Transaction Successful.” ✅ Simple, right? Not really. Behind that tiny confirmation message, several systems have alre30
SJSushama Jangleinoracleapexsessionstate.hashnode.dev·Aug 6 · 7 min readOne Application, Multiple User Experiences: Building a Role-Based Authorization Framework in Oracle APEX👋 Introduction When I started building one of my Oracle APEX applications, my initial focus was straightforward: create the pages, connect the database, and make sure every feature worked correctly. 02J
MMichaelinmmuehlbeyer.hashnode.dev·Jul 29 · 2 min readConfigure wallets for zdmA short one today :-) As promised a short post how to create & configure the wallets for Oracle ZDM. Depending on your settings and existing setup you could specify up to 6 wallets during a physical m00
LSLuís Santosinlslabsessions.hashnode.dev·Jul 26 · 5 min readWhy Is It Called UTL_I18N? The Numeronyms Hidden in TechWhy Is It Called UTL_I18N? The Numeronyms Hidden in Tech While exploring Oracle Database globalization features, you may come across a package with a slightly unusual name: UTL_I18N At first glance, 00
MMichaelinmmuehlbeyer.hashnode.dev·Jul 23 · 8 min readMigrate OnPrem database to Orace Database@AWS with ZDM using existing standbyExisting setup OnPrem database 19c Primary & Standby - non-CDB architecture Oracle database@AWS - empty CDB already deployed (details below) ZDM installed on EC2 instance (see my blog for details o00
ASArfaat Shaikhinapexcraftbyarfaat.hashnode.dev·Jul 10 · 9 min readFace Detection Login SystemThis document covers the complete implementation of a biometric face detection login system built inside Oracle APEX 24.2. The system replaces or supplements the standard username/password login with 00
USUrh Srecnikinblog.srecnik.info·Jul 5 · 10 min readHow direct-path inserts and one extra row per loop bloated 18 MB into 8 GBI was investigating the code that looked something like this: truncate table t1; for i in 1..300 loop insert /*+ append */ into t1 select 1 from dual connect by level <= p_connect_by_level; 00