UAUptime Architectinuptimearchitect.hashnode.dev·11h ago · 9 min readYour First Oracle Autonomous Database on OCI Always FreeThe single best way to keep your Oracle skills sharp without a license, a server, or a finance conversation is OCI Always Free. It gives you a real, fully managed Oracle database — Autonomous Database00
MMMatt Mulvaneyinmattmulvaney.hashnode.dev·3d ago · 5 min readEnhancing SQLcl Terminal in VSCodeIf you use the SQL Developer for VS Code extension, it will install the latest version of SQLcl in VS Code. Sounds great... right!? Actually, no, not great. Why? For three reasons SQLcl starts in00
JAJuan Andrés Lópezinmetadriven.hashnode.dev·3d ago · 12 min readSQL Assertions in Oracle Database 26ai: A Different Way to Enforce Data IntegrityIntroduction After many years working with Oracle Database, I still run into features that make me wonder how I missed them. That happened recently with SQL Assertions. While reviewing some of the new00
URUTKARSH RANJANindevwithutkarsh.hashnode.dev·4d ago · 9 min readOracle APEX Performance Tuning - 10 Things That Actually Help✍️ Utkarsh Ranjan · Oracle APEX Certified Pro (1Z0-771) · ⏱ 10 min read · Intermediate → Advanced Every APEX developer eventually hits the same wall - the app works perfectly in development, but slow00
LCLech Cieślikinlcieslik.hashnode.dev·4d ago · 3 min readPDF Generation in Oracle APEX Using OCI Document Generator Part 3: Building PDF ReportsIn the previous article, we configured OCI Document Generator and connected it to Oracle APEX. Now it's time to generate our first PDF document. The implementation inside Oracle APEX is straightforwar00
LCLech Cieślikinlcieslik.hashnode.dev·5d ago · 4 min readPDF Generation in Oracle APEX Using OCI Document Generator Part 2: Basic ConfigurationIn the previous article, we looked at the available PDF generation options in Oracle APEX and introduced OCI Document Generator as an Oracle-supported alternative for creating PDF documents from Micro00
AKAdrian Kurinmilesofcode.hashnode.dev·6d ago · 6 min readOne Repo, Many Schemas: Making SQLcl Aware of Where You AreA single repository can easily contain several independently deployed Oracle schemas. That structure works well for version control and CI/CD, but it introduces a small, persistent developer-experienc00
LCLech Cieślikinlcieslik.hashnode.dev·6d ago · 5 min readPDF Generation in Oracle APEX Using OCI Document Generator Part 1: Choosing the Right SolutionGenerating PDF documents is one of the most common requirements in Oracle APEX applications. Sooner or later, you will need to generate invoices, contracts, reports, or summaries that users can downlo00
SBsaikat boseinifs-techy.hashnode.dev·Jul 12 · 6 min readQuery Optimization in IFS: The Hidden Performance Killer3 PM on a Monday. Support tickets pouring in. Users can't open the customer form—it just hangs. You know that feeling? I do. I spent the next 2 hours digging through SQL traces, refreshing coffee, mut00
LCLech Cieślikinlcieslik.hashnode.dev·Jul 10 · 9 min readNatural Language for Interactive Reports in Oracle APEX 26.1 - Part 2: Testing and ResultsIn Part 1, we explored how Natural Language for Interactive Reports works and how to configure Report Context and Column Context. In this article, we will focus on practical testing. The goal is to un00