A quick guide to Oracle 26ai’s extended VALUES constructor, showing how to insert, update, and merge multiple rows with cleaner, simpler SQL.
Table Values Constructor In Oracle Database 26ai Read More »
BACKGROUND Consider this problem from LeetCode: leetcode_db_1158, about figuring out for each user, the number of orders they made in 2019. The code below can create the sample data set needed for the question. Here’s an Oracle SQL solution to this problem Notice the left join to a subquery highlighted above! This is done to
Conditional Filter For Aggregates In Oracle Database 26ai Read More »
