Oracle Apex 24.1 Launch Event

Introduction

• Event Overview: Announcing Oracle Apex 24.1
• Speakers: Mike Hitcha (Founder), Sai Natarajan (Cineos Health), Andy Mendelson (Oracle EVP of Database Server Technologies)
• Main Focus: Leverage AI for easier and faster application development

Oracle Apex Philosophy

• Low Code Mindset: Build applications declaratively
• Component Assembly: Utilize components like faceted search, interactive reports, forms, workflow
• Benefits:
  • Rapid problem-solving
  • Easy upgrades (all components get better)

New Release: Apex 24.1

AI Integration

• Apex Assistant: Uses natural language to generate SQL
  • Example: Creating charts and reports by typing natural language instructions
  • Assists with understanding and debugging SQL queries
• Generative AI: Kickstart application creation by describing the app in natural language
  • Example tasks: Create application pages, add features like ACL-based security

Team Collaboration: Working Copy

• Feature: Enables teams to work on features in isolation
  • Named working copies for different tasks
  • Example: Developer Leo works on 'ticket 14' independent of main app
  • Provides comparison tools and merge capabilities

Customer Insight: Sai Natarajan from Cineos Health

• Experience with Apex: Implementing large scale enterprise systems
• Exciting Features:
  • Native Generative AI support
  • Apex Assistant for managing complex data models
• Ease of Use:
  • Importance of easy end-user experience
  • Robust framework prevents breakdowns with small changes
• Choosing Apex:
  • Focus on solving business problems rather than technology
  • Quick value demonstration to leadership

Oracle Database 23AI

New Features for Developers

• AI Vector Search:
  • Use SQL for similarity search on unstructured data (e.g., photos, text)
  • Demo: Social media app using vector search for semantic search
• JSON Relational Duality Views:
  • Combine relational databases and JSON document stores
  • Simplifies updates and data handling
• JavaScript Stored Procedures:
  • Allows usage of modern programming languages like JavaScript alongside PL/SQL

Other SQL Enhancements

• SQL Tweaks:
  • Group by clause improvements
  • Ability to use SQL select without a 'from' clause

Autonomous Database

• Benefits: Simplified cloud experience, powerful infrastructure, pre-integrated with Apex
• Always Free Version: Available for developers to try out

Conclusion

• Call to Action: Try the new features available today
• Encouragement: Visit Oracle online to explore use cases and set up a free workspace

Additional Resources

• Online Workspace: Set up and try Apex 24.1 for free
• Contact: Engage with the community and ask questions for further clarification