Hi,
Currently we're using DBMS_METADATA.get_ddl to extract DDL for objects. While exploring the possibilty to move to SQLcl's DDL-command I've come across an annoying difference when exporting table-definitions.
When using DBMS_METADATA we get the DDL for creating the table, indexes and constraints. But when using the DDL command in SQLcl there are a couple of extra sections in the resulting file we dont' need/want at the moment. These are the column- and table-comments, triggers and an insert-statement (trying to insert rows from an identical table over a non-existing db-link).
So, my question is if it is possible to leave the extra stuff described out when exporting table-DDL using SQLcl's DDL-command? And if so, how can this be achieved?
(db version 19.20.x, SQLcl version 24.2)