You can manipulate #JSON in PL/SQL with: APEX_JSON functions JSON object types Vaibhav Gajare shares examples of these, use cases, and best practices for working with JSON in the database buff.ly/4M6gmX8

Oracle AI Database added the FILTER clause for aggregates in 23.26.1 fn ( ... ) FILTER ( WHERE ... ) Harris Fungwi shows how to use it to solve LeetCode problem 1158: Count a customer's orders for 2019 Check their blog to see how and other solutions

Oracle AI Databaes 23.9 added a UUID() function These generates v4 UUIDs @pdevisser.bsky.social checks it out an looks at methods for generating v7 UUIDs

Convert PL/SQL records and arrays from and to #JSON in Oracle AI Database 26ai JSON_VALUE ( ..., '$' RETURNING <plsql type> ) => JSON to PL/SQL JSON ( <plsql var> ) => PL/SQL to JSON Try it at buff.ly/ewJPfCT

AI agent skills are a set of markdown instructions explaining how to do a task @krisrice.io has built a library of 100+ skills for working with Oracle AI Database with actionable examples, best practices, and common pitfalls Get them at

Stopping users storing overlapping periods is a challenge Oracle AI Database 26ai makes it simple with assertions Rob van den Berg show you how with CREATE ASSERTION ... CHECK ( ALL ( <query> ) t1 SATISFY ( NOT EXISTS ( <overlaps query> ) ) ) buff.ly/qQeuUH6

Make insert-only tables in Oracle AI Database with CREATE IMMUTABLE TABLE ... ( ... ) NO DROP UNTIL m DAYS IDLE NO DELETE UNTIL n DAYS AFTER INSERT Take care with the NO clauses They control when you can delete rows or drop the table @oraclebase.bsky.social demos

Triggers are a common way to track DML changes But it's easy to overlook these when you add new columns! @connormcd.bsky.social shows a compound trigger Oracle AI Database solution Store rowids in a private temp table Join these to the table Get every column with JSON_OBJECT(*)

JSON Schema in Oracle AI Databse 26ai enables you to validate the structure of JSON objects and arrays using DBMS_JSON_SCHEMA @martindba.bsky.social demos how you can use this to check data submitted to the database via REST calls

Sometimes its the small changes that make the big difference Oracle AI Database 26ai added HIGH_VALUE_CLOB HIGH_VALUE_JSON To the partitioning dictionary views => it's easier to query partition boundaries @danischnider.bsky.social discusses

Get the plan for #SQL in Oracle AI Database with dbms_xplan.display_cursor But what if you want to get many at once? @lukaseder.bsky.social demos: SELECT ... FROM v$sql s ,TABLE (dbms_xplan.display_cursor ( s.sql_id, s.child_number )) p WHERE s.sql_text LIKE ...

With SQL/PGQ in Oracle AI Database, you can Create property graphs Query them with GRAPH_TABLE This maps tables and rows to vertices and edges in a graph This enables you to traverse networks of relationships with #SQL Try it at buff.ly/89FnPaf

Preparing for an interview with #SQL questions? Intellipaat covers 15 questions & answers, including Constraints Normalisation DDL and DML commands GROUP BY vs ORDER BY WHERE vs HAVING UNION and UNION ALL Find 2nd highest salary

Want to analyze your Strava data with #SQL? @go-faster.co.uk shows 3 ways you can load it into Oracle AI Database to do this Directly through a JSON Duality View Convert each name-value pair in explicit code Extract Values from JSON in Virtual Columns

Duality views in Oracle AI Databse allow you to design a single, canonical model that satisfies both document and relational APIs @anders-swanson.bsky.social shows you how to use these in a Java app to do CRUD operations andersswanson.dev buff.ly/KHR6LES

Want to connect Python to Oracle AI Database? @antikyte.bsky.social has built a guide of installing & using cx-Oracle with Python 3.6.8 python-oracledb with Python 3.12 Showing how to select from a table execute a packaged procedure execute a packaged function

Override NULL on insert and updates in Oracle AI Database 26ai DEFAULT ON NULL FOR INSERT AND UPDATE The database will replace NULL with the default value in these statements This extends DEFAULT ON NULL added in 12c Try it at buff.ly/G5xNLm7

An arc relationship is when a row can reference exactly one of many parent tables The challenge is when a column in a yet another table defines which is the parent @pdevisser.bsky.social shows how to use assertions in Oracle AI Database to do this

Loops in hierarchical data are a pain Easy to add Hard to prevent @salvis.com shows Oracle AI Database 23.26.1 gives a simple solution Create an assertion limiting the maximum depth to N Do this by joining the hierarchy N+1 times in the assertion

Should these functions return the same value? SELECT ROW_NUMBER() OVER (ORDER BY x), ROW_NUMBER() OVER (ORDER BY x) FROM ... What about when many rows have the same value for X? According to the #SQL standard: yes @winand.at investigates

Oracle AI Database 26ai has a huge number of #SQL enhancements Harris Fungwi covers his favourites: No more FROM dual Shrinking Tablespaces Priority transactions GROUP BY ALL & alias DB_DEVELOPER_ROLE IF [NOT] EXISTS for DDL

The code should read: SELECT JSON_TRANSFORM ( JSON ('{ "arr": [3,2,1] }'), SET '$.origArr' = PATH '$.arr', PREPEND '$.arr' = 10, SORT '$.arr', SET '$.sum' = PATH '@.arr[*].sum()', SET '$.count' = PATH '@.arr[*].count()' ) jarr; HT @thatjeffsmith.com Try it at freesql.com?compressed_c...

Edit #JSON with #SQL in Oracle AI Database with JSON_TRANSFORM ( <json>, <changes> ) Release 26ai added operations for Arithmetic Aggregations PREPEND & SORT arrays COPY MINUS / INTERSECT / UNION set ops MERGE NESTED PATH CASE expressions

Want to query CSV files using Oracle AI Database? Create an external table to access them CREATE TABLE csv ( ... ) ORGANIZATION EXTERNAL ( DEFAULT DIRECTORY ... LOCATION ( 'file.csv' ) ) Then access the file with #SQL Manish Sharma demos

Document objects in Oracle AI Database with schema annotations Define these name-value pairs with ANNOTATIONS ( name { 'value' } {,} ) You can add these to Tables View Materialized View Domains Added in 26ai, backported to 19.28 @oraclebase.bsky.social demos

Oracle AI Database has many tools to help you diagnose performance issues, including Automatic Workload Repository (AWR) Time Model Statistics Performance Tuning Advisors SQL Plan Management @ar-kamrani.bsky.social gives an overview of these

In Oracle AI Database 26ai you can create staging tables: CREATE TABLE ... FOR STAGING ( ... ) These simple tables - Can't be compressed - Have statistics locked - Don't go into the recyclebin when dropped @danischnider.bsky.social investigates

With JSON Relational duality views in Oracle AI Database 26ai you can Define a #JSON API over tables using #SQL or GraphQL Read & write JSON data; the database translates this to relational tables This gives you the benefit of Normalized data storage Simple JSON data access

What to know which #SQL features were added to Oracle AI Database and when? Check the Features and Licensing app apex.oracle.com/database-fea... Use this to: Choose a release and see what's new Find which release a feature first appeared

Oracle AI Database 23.26.1 introduces a suite of date functions to Add X periods Get the date unit Get X period of Y unit Get the date unit start and end For calendar, fiscal, and retail dates e.g. RETAIL_ADD_MONTHS FISCAL_DAY_OF_YEAR @andrejsql.bsky.social demos

There are many #JSON enhancements in Oracle 26ai Join #OracleACE @robbie.databee.org at 2pm UTC 15 April 2026 to learn about The JSON datatype JSON constructors JSON_mergepatch and JSON_transform functions Using flexible domains for JSON Schema validation

Filters like WHERE col IN ( 1, 2, 3, ... ) Could be slow to parse when the IN list has many items To speed these up, Oracle AI Database adds a new vector filter operation This applies to IN lists with 64 or more items @vldbb.bsky.social explains

Stop users in Oracle AI Database making any changes by marking them ALTER USER ... READ ONLY You can also restrict changes within a session with ALTER SESSION SET READ_ONLY = TRUE After setting these, any attempts to write to the database raises ORA-28194

Are you making these 3 database design mistakes? Using string data types for everything Inconsistent naming Aiming for a perfect design from the start Ben Brumm explains why and what to do instead

Define schemas to validate #JSON data in Oracle AI Database CREATE TABLE ... ( col JSON VALIDATE USING '{ <schema> }' ) You can use this to check If the JSON is an object or array The name & type of attributes Constraint their values Anas Darkal demos buff.ly/n30C2Dx

Block #SQL injection attempts on Oracle AI Database with the SQL Firewall This captures a list of permitted statements The database can then reject statements not on this list, keeping your data safe @cafedatabase.com shows how it works (in Spanish)

Use enum domains in Oracle AI Database to create lists of name-value pairs: CREATE DOMAIN ... AS ENUM ( n1, n2, ... ) With these you can Use the enum as a column's data type to constrain it to the enum's values Reference the values by name in #SQL Query the enum like a table

Stretch your #SQL skills with #SQuizL A free guess the SQL statement quiz Every day there's a new Oracle SQL statement to solve in six tries or less Pick from the fragments below to complete the statement on the top left Can you get it in one? buff.ly/hpGFuBa

Do semantic search in Oracle AI Database with the VECTOR data type @adrian.fuzziebrain.com shows you how to Load a pre-trained LLM model into the database Vectorize your data with VECTOR_EMBEDDING Build an APEX app to do AI Vector search

Giving on database user read access to all the tables in another schema is a common need Granting this access for every table is a chore Oracle AI Database 26i simplifies this with GRANT SELECT ANY TABLE ON SCHEMA ... TO ... Diana Robete explains

In Oracle AI Database 26ai you can set transaction priority: ALTER SESSION SET txn_priority = { high | medium | low } When a low priority transaction blocks one with a higher priority, the database can force the lower one to rollback Gavin Soorma demos buff.ly/K6cZocb

Want to partition by an expression in Oracle AI Database? e.g. UPPER ( col ) You can partition on virtual columns containing the expression From 23.26.1 you can put the expression directly in the PARTITION BY clause CREATE TABLE ... ( ... ) PARTITION BY ... ( UPPER ( col ) )

Test your Oracle #SQL and PL/SQL skills in solo, versus, or tournament battles in SchemaWars An online platform with coding challenges by Morten Egan Work on real schemas, enter your solution, and see your score! buff.ly/c8Rkvq9

Graph queries enable you to find Paths and patterns (e.g. flow of money transfers) Clusters of data Do this in Oracle AI Database by creating property graphs and querying them with SELECT * FROM GRAPH_TABLE ( <graph> MATCH ... ) Karin Patenge demos buff.ly/RxCMHZj

Data usecase domains in Oracle AI Database enable you to describe values e.g. rules for storing, showing, & sorting phone numbers CREATE DOMAIN phone# AS ... CHECK ... DISPLAY ... ORDER ... @dbamarco.bsky.social shows how linking these to columns applies the rules

With #JSON duality views in Oracle AI Database you can build a JSON interface over database tables These come with lost-update detection via ETags @martindba.bsky.social shows how this prevents conflicting writes for REST calls by using the if-match header

Count the unit boundaries crossed between two datetimes with DATEDIFF ( <unit>, <dt1>, <dt2> ) Note it's the boundaries crossed, not the duration e.g. 31-Dec-2025 to 2-Jan-2026 crosses the 1st Jan boundary => the year diff = 1 Added to Oracle SQL in 23.26.1

Calling #OracleACE: we want your assertion use cases! We’re opening a bounty for creative, real-world solutions using assertions Submit your blog post, video, script or slide deck the contribution app by the end of 15 March Full details at buff.ly/fNgDHQv

Think you know about #SQL performance? Take this 3-minute indexing quiz by @winand.at A simple test that 60% fail! buff.ly/5C4XZ7N Did you pass? Let us know how you did!

Struggling to remember which #SQL statements you just ran? Set sql_history_enabled = true in Oracle AI Database 26ai and it records the last 50 statements in each session Query v$sql_history to find them @brendan-tierney.bsky.social demos