CREATE OR REPLACE PACKAGE my_api
IS
PROCEDURE this (n NUMBER);
PROCEDURE that (d DATE);
END;Package created.
BEGIN
DBMS_OUTPUT.put_line (
DBMS_METADATA.get_ddl ('PACKAGE', 'MY_API'));
END;CREATE OR REPLACE EDITIONABLE PACKAGE "SQL_NAEFZCMDKYEYHEGFJWMZRICLT"."MY_API" IS PROCEDURE this (n NUMBER); PROCEDURE that (d DATE); END;
CREATE TABLE my_table
(
n DATE,
s VARCHAR2 (100),
d DATE
)Table created.
BEGIN
DBMS_OUTPUT.put_line (
DBMS_METADATA.get_ddl ('TABLE', 'MY_TABLE'));
END;CREATE TABLE "SQL_NAEFZCMDKYEYHEGFJWMZRICLT"."MY_TABLE" ( "N" DATE, "S" VARCHAR2(100), "D" DATE ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "LIVESQL_USERS"
CREATE TYPE my_object IS OBJECT
(
n DATE,
s VARCHAR2 (100),
d DATE
)Type created.
BEGIN
DBMS_OUTPUT.put_line (
DBMS_METADATA.get_ddl ('TYPE', 'MY_OBJECT'));
END;CREATE OR REPLACE EDITIONABLE TYPE "SQL_NAEFZCMDKYEYHEGFJWMZRICLT"."MY_OBJECT" IS OBJECT ( n DATE, s VARCHAR2 (100), d DATE )
Call GET_DDL in SQL
SELECT DBMS_METADATA.get_ddl ('TYPE', 'MY_OBJECT')
FROM sys.dual| DBMS_METADATA.GET_DDL('TYPE','MY_OBJECT') | CREATE OR REPLACE EDITIONABLE TYPE "SQL_NAEFZCMDKYEYHEGFJWMZRICLT"."MY_OBJECT" IS OBJECT ( n DATE, s VARCHAR2 (100), d DATE ) |
|---|