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
RGRafal Grzegorczykinrafal.hashnode.dev·Jun 24 · 4 min readHow to securely connect MCP to the database (using Oracle DB 26AI and SQLcl) ?What should we do to be sure of what AI can do using the SQLcl MCP server and what data is accessible to it? Are there any extra security precautions we could take in case AI go crazy? That's exactly 00
RGRafal Grzegorczykinrafal.hashnode.dev·Jun 23 · 2 min readHow to quickly add SQLcl MCP Server to Visual Studio Code?In this short guide, I’ll show you how to quickly add an SQLcl-based MCP server in Visual Studio Code so you can start “talking” with your Oracle Database using AI. No complex setup, no huge framework00
MMichaelinmmuehlbeyer.hashnode.dev·Jun 23 · 4 min readHow to install Oracle Zero Downtime Migration (ZDM)Oracle Zero Downtime Migration (ZDM) is a free to use software which allows you to automate your database migrations to OCI, multicloud and onprem systems some Prerequisites It's highly recommended to00