Top "Dbms-metadata" questions

An Oracle package that enables the retrieval of an objects metadata.

Get VIEW ddl using query

For database re-architecture I need to get DDL of each table and view in the database(Oracle). I don't want …

sql oracle ddl dbms-metadata
Oracle's dbms_metadata.get_ddl for object_type JOB

I'd like to create ddl scripts for most of my database objects. dbms_metadata.get_ddl works for most of …

oracle oracle10g jobs ora-06512 dbms-metadata
Generating DDL script for object without schema name baked in using DBMS_METADATA.GET_DDL?

How can I generate the DDL script for my object with DBMS_METADATA.GET_DDL without the schema name baked …

oracle dbms-metadata
How to make dbms_metadata.get_ddl more pretty/useful

I am creating a package to generate the DDL of objects in my schema (you parse the object name, and …

oracle ddl plsqldeveloper dbms-metadata
Get complete ddl for index in oracle

I am using oracle 11g/12c. I want to get ddl of indexes in my database. For this I used …

oracle sqlplus dbms-metadata