There’s no conference quite like ODTUG’s Kscope, and this year in Grapevine proved it once again. From the moment the exhibit hall opened to the final session on Thursday, our team was all-in—soaking up the learning, connecting with the community, and having a genuinely great time.
We kicked things off with strong energy at the Sunday Symposium and never looked back. Open Mic Night gave us a chance to showcase one of our own projects on stage—quick, live, and unscripted—while the Silent Disco that followed proved that even database nerds have dance moves (or at least enough enthusiasm to fake it). At our booth, the Oracle of APEX made its Kscope debut, delivering eerily accurate fortunes to anyone brave enough to spin the wheel and claim their t-shirt prize. (Spoiler alert: The Oracle sees AI in your future.)
We handed out stacks of shirts, met dozens of talented developers, and reconnected with friends and clients we hadn’t seen since last year. We also met plenty of new faces—including some great folks from the EPM track. With APEX as the base for critical new EPM modules, it was exciting to start building those bridges early. And of course, the Stars Over Texas event on Wednesday night was a highlight—not just for the food, live band karaoke, and 300-drone light show—but for the chance to unwind and celebrate what makes this community so special: real people who care deeply about what they build.
Amid all the fun, we also attended dozens of sessions. And while the topics were wide-ranging, a few clear trends stood out—signals about where Oracle APEX is headed and how developers can make the most of it.
Here are our five biggest takeaways from Kscope25:
1. AI in APEX: Power, Not Pixie Dust
AI was the dominant theme across the APEX track, but unlike past years, this wasn’t just hype—it was practical, real, and available in today’s tools. Oracle is embedding AI deeply into APEX, but success still depends on thoughtful implementation and developer knowledge.
- Natural Language Development: Quickly generate tables and pages using Quick SQL and natural language prompts. Sample data can now be auto generated based on report type and region.
- Retrieval-Augmented Generation (RAG): APEX 24.2 introduces native support for RAG, improving AI accuracy by allowing large language models to “see” your data via SQL queries, static data, or PL/SQL functions.
- Token Control Matters: You can now set limits and conditions to reduce API token usage in AI calls—helping manage cost and output precision.
- Embedded AI Assistants: A new Dynamic Action option lets you add an AI assistant directly into your page. Just define your prompt and select your provider (OpenAI, Cohere, or OCI GenAI).
- But Know Your Data: Many speakers emphasized that these tools aren’t magic. AI assistants won’t replace your knowledge of PL/SQL, schema design, or app logic.
Takeaway: AI is now a practical part of Oracle APEX development—but to use it effectively, developers need to understand how to guide it with structure, context, and code.
2. Standardization and Scale with CI/CD and Shared Components
As APEX apps grow in complexity, Oracle continues to roll out features that make it easier to manage, deploy, and maintain them at scale. Kscope25 showcased several ways to bring modern development practices into APEX workflows.
- SQLcl Projects: A new feature that packages your APEX, PL/SQL, and database artifacts into a coherent project structure—allowing for version control and automated deployment pipelines.
- YAML and APEXlang: Export APEX apps as readable, diffable files. APEXlang is a new intermediate language that provides better transparency and control over app exports.
- Split File Exports: Move beyond monolithic APEX exports. Split files allow for granular tracking of changes across components.
- Project Stage Commands: Automatically detect schema and UI changes and generate deployment scripts in the correct order—reducing risk during updates.
- Centralized Standards: Oracle is promoting global repositories, pattern pages, and reusable component libraries to encourage design consistency across apps and teams.
Takeaway: APEX is evolving into a more mature platform for enterprise-scale development. With tools like SQLcl Projects and YAML exports, the CI/CD story is no longer an afterthought—it’s becoming the default.
3. Design Matters: UX and UI Take the Spotlight
A standout trend at Kscope25 was the number of sessions focused on user experience and visual design. APEX developers are clearly being encouraged—and empowered—to treat UI/UX as a core part of their development practice.
- Template Components: Developers can now define reusable, slot-based UI blocks that simplify layouts, support dynamic content, and allow for cleaner code organization.
- CSS Variables and Theme Customization: Redefine core visual elements—like color schemes, spacing, and typography—using CSS variables for consistent theming and easier updates. This approach helps future-proof your design and supports dark/light mode without overriding Universal Theme styles.
- Theme Roller & Custom Templates: Create branded, responsive experiences by combining theme facets, versioning, and clean markup. You can now build pixel-perfect UIs without leaving APEX.
- Design Best Practices: Keep apps “boring” in the best way—simple, fast, and readable. Use structure to guide the user: navigation pages, breadcrumbs, visible parameters, and intentional page layouts.
- Mobile Considerations: Prioritize clarity and interaction. Floating labels, icon overuse, and mismatched color meanings are all UX pitfalls to avoid.
Takeaway: With better tools and more education, APEX is no longer just about function. Developers are expected to build apps that look professional and feel effortless.
4. Oracle 23ai Unlocks Next-Gen Features for APEX Developers
If Oracle APEX is the engine for rapid application development, then Oracle Database 23ai is the new premium fuel. Nearly all of the latest AI-powered capabilities in APEX—especially vector search and Retrieval-Augmented Generation (RAG)—depend on the features introduced in 23ai. But the benefits go far beyond AI.
- Vector Search: Enables advanced AI features like similarity matching and semantic search. It’s a prerequisite for real RAG support, reducing token usage and improving LLM output relevance.
- Hybrid Indexes: Combine text, fuzzy, and vector indexes in one structure, enabling more nuanced querying of both structured and unstructured data.
- No More Wallet Files: 23ai eliminates the need for wallet-based HTTPS authentication in many cases, simplifying external API calls and REST integrations.
- Improved Performance: Read-only cache modes and patching improvements (like out-of-place patching) make apps faster and upgrades less disruptive.
- Multicloud and Edge-Ready: Combined with Autonomous Database and ORDS, 23ai supports the architecture and availability patterns needed for global apps.
Takeaway: Upgrading to Oracle Database 23ai isn’t just about staying current—it unlocks core functionality that modern APEX applications now expect. Teams still on 19c are going to find themselves increasingly left out of the loop when it comes to AI and other advanced capabilities.
5. APEX Mobile and PWA Are More Capable Than Ever
Oracle continues to invest in mobile-friendly and Progressive Web App (PWA) features—ensuring APEX apps work seamlessly across devices, even without native app stores. Sessions at Kscope25 revealed how developers can now build polished, mobile-responsive experiences using only native APEX tools, enhanced with CSS, JavaScript, and Template Components.
- Push Notifications and Installable Apps: Developers can now send real-time alerts and configure installable shortcuts directly from the home screen, mimicking the behavior of native apps.
- Template Components for Mobile Layouts: APEX’s slot-based layout system allows fine-tuned control over mobile UI, enabling developers to tailor screen experiences without breaking responsive behavior.
- Offline Support and PWA Enhancements: Features like page caching, manifest configuration, and app screenshots improve the ability to install and perceived performance of PWAs.
- Design Patterns that Travel Well: Using clean utility classes, card-based layouts, and trimmed-down navigation menus ensures that APEX apps look and feel consistent across devices—even in low-bandwidth or multitouch scenarios.
Takeaway: Mobile development in APEX isn’t a second-class experience anymore. With just a little know-how, developers can create enterprise-grade mobile interfaces that are fast, intuitive, and fully functional on the go.
From Grapevine to the Rockies—Let’s Keep Building
Kscope25 reminded us just how much momentum the APEX community has—and how much creativity, generosity, and technical excellence is driving it forward. Every hallway conversation, demo, and late-night discussion reinforced that this is a space full of people who care not just about building great software but about helping each other get better.
We’re heading home with fresh ideas, new connections, and plenty of energy to keep pushing our work (and yours) to the next level. And we’re already looking forward to what’s next. Kscope26 lands in Denver next June 14–18, and if this year was any indication, it’s going to be another can’t-miss event for APEX professionals and Oracle developers of all stripes.
