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.3 days ago — edited 3 days ago

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 3 days ago
1 comment
66 views