Here’s the MCP demo I presented at Oracle APEX AI Days in Chennai, Gurgaon, and Hyderabad. The video showcases an end-to-end workflow using Claude Desktop and SQLcl MCP Server, connected to Oracle Autonomous Database. It demonstrates: • Connecting to the database • Data modeling • Filling tables with sample data • Writing and executing PL/SQL • Generating and running test cases • Preparing migration scripts • Exporting the APEX application Thanks to India Oracle APEX User Group, Oracle, and all the attendees across the three cities. Sharing the recording here for anyone who wants to explore how MCP can transform the APEX development lifecycle. #OracleAPEX #MCP #SQLcl #APEXAIDays #INOAUG #AI #AutonomousDatabase #orclAPEX #maathra Maathra Technology and Consultancy Pvt Ltd

Check out this awesome demo that shows how MCP can transform the APEX development lifecycle! Developers can focus on creating high-quality applications without worrying about the underlying infrastructure, which is managed by the cloud platform. Whether it’s through faster deployment, better collaboration, or enhanced security, MCP offers a robust foundation for modern APEX development.

Oracle Database 23ai simplifies SQL by making FROM DUAL optional. Starting with Oracle Database 23ai (23c), simple SELECT statements no longer require the DUAL table. Queries such as function calls or expressions can be written without referencing DUAL explicitly. This enhancement improves readability and reduces unnecessary syntax, while the database engine continues to handle execution internally in the same way. Although a small change, it contributes to cleaner SQL and faster query writing—especially for ad-hoc and learning scenarios. Staying aware of such enhancements helps SQL professionals keep their skills aligned with modern Oracle releases. — Shared by Unisoft Technologies Nagpur 🔖 Hashtags #OracleDatabase #Oracle23ai #SQLDevelopment #DatabaseEngineering #AnalyticsProfessionals #SQLLearning #UnisoftTechnologies

🔁 Repost if you believe DBAs are evolving — not disappearing AI Vector Search & Vector Embeddings in Oracle AI Database 26ai 👉 https://lnkd.in/g74bdg5m In this video, Rob Watson and I break down — DBA-style, no hype 👇 We explore Oracle AI Vector Search and walk through the end-to-end workflow in Oracle AI Database 26ai—using pure SQL and native database features. ✅ What vector embeddings really are (in database terms) ✅ How vector embeddings are generated from unstructured data ✅ How Oracle AI Database 26ai stores & searches vectors ✅ When and why vector indexes are used to accelerate similarity search ✅ Why vector search is NOT full table scan + magic ✅ How DBAs stay relevant in the AI era Oracle didn’t bolt AI onto the database. Oracle built AI into the database kernel. If you manage performance, indexes, SGA, or Exadata — you already have a head start in AI. 🎯 This video is for: • Oracle DBAs • Performance engineers • Exadata specialists • Architects exploring GenAI + RAG • Anyone who wants to future-proof their database skills 👇 Drop a “VECTOR” in comments if you want: • Demo SQL scripts • Vector Pool and Vector Indexes architecture diagrams • HNSW, IVF, Hybrid Vector index details and demos 🔁 Repost if you believe DBAs are evolving — not disappearing 👉 Like, subscribe, and stay tuned for upcoming deep-dive videos on vector indexes, AI Smart Scans, Active Data Guard AI Inferences and RAG inference demos. #OracleDatabase #OracleAI #VectorSearch #Oracle26ai #DBACommunity #Exadata #GenerativeAI #DatabaseEngineering #FutureOfDBA

Oracle Database 23ai introduces GROUP BY ALL — a small syntax change with meaningful impact. The new GROUP BY ALL syntax automatically groups results by all non-aggregated columns in the SELECT list, removing the need to explicitly mention each column in the GROUP BY clause. This enhancement helps: Simplify complex and ad-hoc queries Reduce manual errors Improve query readability Speed up SQL development Internally, the database engine still expands the query to include all required columns, making this a syntactic convenience rather than a behavioral change — but a very useful one for learners and working professionals. Staying updated with such features is important for anyone working with modern SQL and analytics tools. — Shared by Unisoft Technologies Nagpur #OracleDatabase #Oracle23ai #SQL #Nagpur #SQLDevelopment #DatabaseLearning #AnalyticsSkills #SQLProfessionals #UnisoftTechnologies #ITTrainingNagpur

So you think you know SQL. It's like having a superpower - you can filter out anything you don't need. You want specific rows, not all rows. That's where the WHERE clause comes in - it's like a filter button, helping you narrow down your search. It's simple: you use it to get specific data from your database. But, there's more to it. The WHERE clause has 5 types of operators: comparison, logical, range, membership, and search. Comparison operators compare values - like =, !=, >, <, >=, <=. You use these to compare one value with another, like selecting all students where age = 20. And then there are logical operators - AND, OR, NOT - which combine conditions or reverse them. For example, selecting all students where marks > 80 and age < 22. Range operators, like BETWEEN, include both values - so you can select students with marks between 60 and 80. Membership operators, like IN, check from a list - like selecting students from Delhi, Mumbai, or Pune. Search operators, like LIKE, are for pattern matching - so you can find all students with names starting with 'A'. It's pretty cool. Source: https://lnkd.in/g7-tXm8g #SQL #DatabaseManagement #DataFiltering

Bringing AI into Oracle APEX is no longer a future idea. It is already practical and achievable. Visit article for more info: https://lnkd.in/gJpnSjtw At Oracle APEX UTSAV 2025, we spoke about how APEX applications can move beyond traditional form-based systems and become intelligent, context-aware platforms. One of the most engaging use cases we discussed was building an “Ask My Document” feature using Retrieval-Augmented Generation (RAG) with Oracle 23ai. The session covered: What RAG really means in real-world applications How Oracle 23ai enables secure, database-driven AI use cases Architecture of an AI-powered document Q&A system in Oracle APEX Live demo showcasing how users can query documents in natural language The goal was simple: show how AI can solve real business problems inside APEX without overengineering or external complexity. We’ve now shared a detailed article that walks through the concept, architecture, and demo showcased during the session. If you’re working with Oracle APEX and wondering where AI actually fits in, this is a good place to start. INOAUG India Oracle APEX User Group Ashish Sahay Suman Singh Vikas Pandey #moca #lowcode #ontoor #ontoorsolutions #OracleAPEX #Oracle23ai #RAG #AIinAPEX #APEXCommunity #INOAUG #orclapex

Oracle Database 23ai introduces Boolean expressions in SQL Traditionally, Oracle SQL lacked native Boolean support, limiting the direct use of TRUE and FALSE values in SQL queries. This often created inconsistencies between SQL and PL/SQL logic. With Oracle Database 23ai, Boolean expressions are better supported within SQL, allowing: Cleaner conditional logic Improved readability Stronger alignment between SQL and PL/SQL Although this may appear subtle, it significantly improves developer experience when building complex conditions, filters, and logic-driven queries. Staying current with such enhancements is essential for professionals working with modern Oracle databases. — Unisoft Technologies, Nagpur 🔖 Hashtags #OracleDatabase #Oracle23ai #SQLDevelopment #DatabaseEngineering #AnalyticsProfessionals #ModernSQL #UnisoftTechnologies

Enhance Collaboration & Data Clarity with Oracle SQL Developer  Data teams thrive when information is clear, consistent, and easy to understand. With Oracle SQL Developer, the free integrated development environment for Oracle AI Database, you can now enrich your database schemas with powerful annotations that elevate data quality and organizational insight. In this new demonstration, you’ll see how simple it is to add rich, descriptive metadata—including business terms, aliases, and detailed descriptions—to your tables and columns. These annotations streamline data management, strengthen governance, and help teams work with greater confidence. 🔍 Explore more:   Check out the key features of Oracle SQLcl: https://lnkd.in/dupBv7sW With the AI Enrichment Dashboard, you can:   ✨ Apply annotation best practices   ✨ Ensure portability across Oracle Database 19 and Oracle AI Database 26ai   ✨ Use free‑form annotations to clearly express the semantics and intent behind your data structures  These enhancements not only improve team collaboration—they also help large language models (LLMs) better understand enterprise context, accelerating development and improving AI‑driven insights. 💡 Ready to get started?   Download Oracle SQL Developer today: https://lnkd.in/dHWcBhzA  📘 Need step‑by‑step guidance?   Get detailed instructions for using AI Enrichment in Oracle Database 26ai: https://lnkd.in/dhrNR7Gj  📨 Like what you're learning about Oracle Database 26ai?   Subscribe now: https://lnkd.in/dEkcF5Ys  🎬 https://lnkd.in/db9ekVNk 🔖 #Oracle #OracleDatabase #OracleAI #OracleSQLDeveloper #SQLDeveloper #Oracle26ai #DataManagement #AIEnrichment #DatabaseDevelopment #MetadataManagement #LLM #DataGovernance #TechInnovation #Developers #CloudTech

Quick introduction to Vector Databases and Oracle 26ai that integrates Vectors with existing data structures and SQL, PLSQL etc used in existing Oracle implementations.