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!

SQLcl project export - inconsistent sorting of unique indices

M. Tr.Nov 13 2025 — edited Nov 13 2025

Hi,

We’re facing an issue where the project export process generates diffs for tables because the sorting of unique indices in the CREATE TABLE statements is inconsistent. On different machines (with varying database versions), we end up with the same CREATE UNIQUE INDEX statements, but they appear in a different order. This is quite inconvenient. Is there a way to fix this, or does anyone know a good workaround? We use the most recent sqlcl 25.3.2.0 delivered with VSCode.

Comments
Post Details
Added on Nov 13 2025
4 comments
119 views