Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Will SQLcl Project Support 26ai DB Assertions Anytime Soon?

Alexander KluevMar 18 2026 — edited Mar 18 2026

Hi team,

My client upgraded the database to 26ai and I'm planning to start using database assertions asap. For those who don't know, assertions are brand new objects in 26ai, kind of multi-table , multi-row check constraints. For example, a primitive version of assertion may look like that:

CREATE ASSERTION check_president_salary CHECK (
    EXISTS (SELECT 1 FROM emp WHERE job = 'PRESIDENT' AND sal BETWEEN 4000 AND 10000)
);

My question: Are there any plans to support assertions in project export and project stage commands in the near future?

Best,

Alex

This post has been answered by thatJeffSmith-Oracle on Mar 18 2026
Jump to Answer
Comments
Post Details
Added on Mar 18 2026
2 comments
79 views