RRameen ZafarSep 21 · 11 min readExposing Database APIs in Oracle APEX: Building Declarative REST Services with ORDSBuilding custom REST APIs for mobile apps, third-party integrations, or microservices usually means writing backend boilerplate: connection pools, JSON serialization, authentication, error mapping. Iforacle-impact.hashnode.dev
TTimo HerwixSep 4 · 12 min readBuilding my Oracle APEX 26.1 AI Playground with Oracle AI Database 26ai, ORDS, SQLcl, Codex, MCP and APEXlangIntroduction Over the last few days I wanted to build a personal Oracle APEX playground for experimenting with modern AI-assisted development workflows. My goal was simple: Oracle AI Database 26ai Frtm-apex.hashnode.dev
MMatt MulvaneyAug 24 · 2 min readAPEXLang + Windows? Add this one Git settingExcited to play around with APEXLang or SQLcl Project? What are you going to do? Vibe Code some APEXLang Export / Import APEX apps Project Export your schema Sounds fun right? By the experiences mattmulvaney.hashnode.dev
MMatt MulvaneyAug 24 · 2 min readSYS.VALIDATE_APEX : Fix-all for Upgrade issues Upgraded something? - don't let let issue find you first, just run the following as SYS after switching to your PDB -- CONN / AS SYSDBA -- ALTER SESSION SET CONTAINER=FREEPDB1; begin sys.validate_mattmulvaney.hashnode.dev
MMatt MulvaneyJul 17 · 8 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 inmattmulvaney.hashnode.dev
MMatt MulvaneyJun 16 · 3 min readOracle APEX Shared Components Menu Button If you have an idea how to make Oracle APEX better - then you should submit your idea here https://apex.oracle.com/ideas The team regularly meet to discuss the ideas and your idea could become part ofmattmulvaney.hashnode.dev
MMatt MulvaneyJun 15 · 3 min readClaude Code & SQLcl MCP serverFirst follow this guide to set up your working Claude Desktop & SQLcl MCP server. You at least need to get to this screen showing sqlcl running as an MCP server Claude Desktop and Claude Code do notmattmulvaney.hashnode.dev
MMatt MulvaneyJun 1 · 6 min readAPEX 26.1 Upgrade Strategy and Infrastructure RequirementsWhen installing or upgrading APEX it's normally a tried and trusted process. However with the release of APEX 26.1, there are a few things to bear in mind regarding the upgrade procedure. Database Rmattmulvaney.hashnode.dev
MMatt MulvaneyJun 1 · 7 min readRESTful Services AuthorizationWelcome, in this blog, we are going to talk about Basics of securing RESTful Services Protecting RESTful Services Using Client to access protected RESTful Services Basics again - but written in a mattmulvaney.hashnode.dev
MMatt MulvaneyJun 1 · 3 min readAPEX 26.1 Understanding the Metric Card AttributesThe Metric Card is new? Is it good? Yes its good. Why? its Native, its easy to configure. The attributes make sense even with the niggles - read on to see what I mean. How is this attribute used? Whicmattmulvaney.hashnode.dev