LinkedIn·Tuesday, 25 August 2026·22h ago
🎬 Kicking off a new weekly series with Philipp Hartenfeller: each week, one Oracle SQL or PL/SQL rule and the sneaky bug it prevents.…
United Codes
1,607 followers
🎬 Kicking off a new weekly series with Philipp Hartenfeller: each week, one Oracle SQL or PL/SQL rule and the sneaky bug it prevents.
First up is rule G-3185. Picture a query asking for your five highest-paid employees. It runs cleanly and returns five rows, handing you the wrong people without any warning.
The cause is timing. ROWNUM gets assigned before ORDER BY sorts anything, so the database keeps the first five rows it happens to find and only sorts those. Switching to RANK() with FETCH FIRST resolves it, since FETCH FIRST does its work after the sort completes.
dbLinter catches this the moment you type it, right inside VS Code. It's one of 180+ rules based on the Trivadis Coding Guidelines, scanning your Oracle SQL and PL/SQL as you write so problems surface well before production.
Catch problems before production 👉 https://lnkd.in/e-D4dCGz
#OracleAPEX #OracleDatabase #PLSQL #SQL #dbLinter #CodeQuality #orclapex
♥ 15↻ 4
View on LinkedIn Cross-referenced
Related on the wire
Feeling so proud today! Our very own Vito Van Hecke just became an Oracle ACE Associate. ♠️ If you've ever seen Vito present, you know the…
New in APEX Project Eye 26.2: Watchtower Summary Watchtower now places a compact summary of every scan directly on your dashboard, so the…
👁️ APEX Project Eye 26.2 is here, and it brings SLA to Watchtower. Compliance checks often live in someone's memory or a scattered…
APEX Project Eye (APE) 26.2 is here, and it's our biggest Watchtower release yet. This update makes proactive monitoring simpler to run and…
Ever struggle to visualize complex financial flows? We just showed how to turn Oracle's quarterly financial data into stunning interactive…
Missed our latest United Codes Live!? The recording is ready to watch. The long-awaited APEX 26.1 release is here, and it brings APEXlang,…