23ai: Direct join with DELETE

By | | ,

As new features within the 23ai Oracle database, we can use the join in the delete 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
  • Detele query within Oracle database 19c
  • Delete query within Oracle database 23ai

Step 1: Create two tables

Step 2: Insert some rows in both tables

Step 3: Detele query within Oracle database 19c

Step 4: Delete query within Oracle database 23ai

Enjoy!

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply