Calling all Oracle ACEs: we want your assertion use cases!

select use_cases from assertions where creator = 'Oracle ACE' order by real_world_applicability + complexity + novelty desc fetch first 3 rows only

Assertions (added in 23.26.1) let you define cross-row, cross-table constraints. We’re opening a bounty for creative, real-world solutions.

To enter, create a blog post, video, script or slide deck. Explain the use case and show how to implement it with assertions.

Your submission must include:

  • A clear description of the problem.
  • A complete example that demonstrates the solution with assertions.

We’ll pick the top three submissions based on:

  • Problem complexity
  • Solution novelty
  • Real-world applicability

Submit your entry in the ACE Contribution app and select the “Assertions Use Cases” bounty.

The closing date is Sunday 15th March 2026. We’ll judge the entries and pick our top three by Monday 23rd March 2026.

Need help understanding assertions? Get up to speed with these resources:

Or watch the recording of the Ask TOM Live session on assertions: