F\u00fcr Output in der DBMS-Ausgabe erzeugt der folgende Code die komplette Tabellendefinition inkl. Indizes, Kommentare und Grants:<\/p>\n\n\n\n
DECLARE
ddl CLOB;
comments CLOB;
grants CLOB;
v_owner VARCHAR2(100) := ‚OWNER_HIER_EINSETZEN‘;
v_table VARCHAR2(100) := ‚TABELLE_HIER_EINSETZEN‘;
BEGIN
SELECT DBMS_METADATA.GET_DDL(‚TABLE‘, t.table_name, t.owner)
INTO ddl
FROM all_tables t
WHERE owner = v_owner AND table_name = v_table;<\/p>\n\n\n\n
FOR i IN (SELECT index_name FROM all_indexes WHERE table_owner = v_owner AND table_name = v_table) LOOP
ddl := ddl || CHR(10) || DBMS_METADATA.GET_DDL(‚INDEX‘, i.index_name, ‚MDM‘);
END LOOP;<\/p>\n\n\n\n
SELECT DBMS_METADATA.GET_DEPENDENT_DDL(‚COMMENT‘, v_table, v_owner)
INTO comments
FROM dual;<\/p>\n\n\n\n
SELECT DBMS_METADATA.GET_DEPENDENT_DDL(‚OBJECT_GRANT‘, v_table, v_owner)
INTO grants
FROM dual;<\/p>\n\n\n\n
— Hier k\u00f6nnen Sie das vollst\u00e4ndige DDL-Statement mit Kommentaren und GRANTs ausgeben
DBMS_OUTPUT.PUT_LINE(ddl || CHR(10) || comments || CHR(10) || grants);
END;
\/<\/p>\n","protected":false},"excerpt":{"rendered":"
F\u00fcr Output in der DBMS-Ausgabe erzeugt der folgende Code die komplette Tabellendefinition inkl. Indizes, Kommentare und Grants: DECLAREddl CLOB;comments CLOB;grants CLOB;v_owner VARCHAR2(100) := ‚OWNER_HIER_EINSETZEN‘;v_table VARCHAR2(100) := ‚TABELLE_HIER_EINSETZEN‘;BEGINSELECT DBMS_METADATA.GET_DDL(‚TABLE‘, t.table_name, t.owner)INTO ddlFROM all_tables tWHERE owner = …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,4],"tags":[16,17,18],"class_list":["post-100","post","type-post","status-publish","format-standard","hentry","category-oracle","category-plsql","tag-oracle","tag-pl-sql","tag-tabellendefinition"],"_links":{"self":[{"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/posts\/100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=100"}],"version-history":[{"count":1,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/posts\/100\/revisions"}],"predecessor-version":[{"id":101,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/posts\/100\/revisions\/101"}],"wp:attachment":[{"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}