23ai: Direct join with UPDATE

By | |

As new features within the 23ai Oracle database, we can use the join in the update query, in this tutorial we are going to make un example to compare the query with Oracle database 19c and 23ai.

Steps

  • Create two tables
  • Insert some rows in both tables
  • Update query within Oracle database 19c
  • Update query within Oracle database 23ai

Step 1: Create two tables

Step 2: Insert two rows in both tables

Step 3: Update query within Oracle database 19c

We have syntaxe errors:

Step 4: Update query within Oracle database 23ai

Enjoy!

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply