Working with JSON and Dates in Oracle AI Database 26ai @oracledevs
Working with JSON and Dates in Oracle AI Database 26ai  @oracledevs
Uploaded July 2026 | Updated November 2026, 3 days ago
Working with JSON data and datetime values can be challenging. While the JSON data type only allows valid documents, they can still have any structure. This means expected attributes may be missing, making querying it tricky. Datetime calculations to account for fiscal or other non-standard calendars are complex. Ensuring optimal performance for both types needs careful tuning.

Oracle AI Database 26ai has many enhancements to simplify working with these types. We'll cover new methods to validate the schema of JSON documents. Then we'll look at a range of datetime functions added in 26ai. These provide simple APIs to find time boundaries crossed and work with fiscal and retail calendars. And we'll show techniques to optimize all these queries.

Watch this session to see demos of these features in action. If you do data analysis or build apps that work with these values you'll learn tips and tricks to help simplify your SQL.

Highlights include

01:00 - JSON query challenges
09:04 - Overview
11:21 - Verifying JSON
14:35 - JSON type modifier demo
17:15 - JSON schema demo
20:42 - Date logic complexity
25:50 - Datediff/dateadd demo
34:25 - Calendar functions demo
41:27 - Indexing challenges
45:30 - Optimizing JSON and date queries
50:25 - JSON indexes demo
57:15 - Closing
Working with JSON and Dates in Oracle AI Database 26aiHow to Troubleshoot Failed CI/CD Builds with an AI AgentOCI Console AI Early Access PreviewOracle AI Developer Hub: Check This Before You Run a NotebookTypes of Long-Term Memory for AI Agents, ExplainedWhat Is an Agent Harness? Model + Harness = AI AgentAngie Jones on why agent memory matters #OracleDevelopers #AI #Developers #CreatorLabsOracle Deep Data Security and Java Application Development for Agentic AIPart 8 - Execute the CD3 Automation toolkit using Jenkins to export resources from OCIPart 7 - Execute the CD3 Automation toolkit using Jenkins to create resources in OCIBuild JSON and SQL Applications with Oracle AI Database JSON Data GuideProduction-Ready AI Agent Memory: The Rebuild Test
Oracle Developers |

Working with JSON and Dates in Oracle AI Database 26ai

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER