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!

Modeler DDL - Choose a SubView?

J-Apr 4 2025

In SQL Developer Data Modeler, in the DDL Editor window, in the relational model dropdown, I can choose either the relational model OR a subview of that relational model. This will generate DDL just for the objects within that subview.

In SQLcl, I was hoping I could just use a subview name for the modeler ddl -relmodel option (since the DM application has the subviews and relational models in the same dropdown).

But that fails and says the relational model was not found.

Is there a way to run SQLcl modeler ddl on a subview?

Comments
Post Details
Added on Apr 4 2025
0 comments
105 views