I'd like to create ddl scripts for most of my database objects. dbms_metadata.get_ddl works for most of the object types. For instance the following creates the ddl for a view: select dbms_metadat...

How can I generate the DDL script for my object with DBMS_METADATA.GET_DDL without the schema name baked in? With DBMS_METADATA.GET_DDL: CREATE TABLE "MYSCHEMA"."MYTABLE" ( "COL1" NUMBER(10,0) )...

For database re-architecture I need to get DDL of each table and view in the database(Oracle). I don't want to go to property of each table/view and get SQL out of it in SQL Developer. I successfu...

I am creating a package to generate the DDL of objects in my schema (you parse the object name, and return a clob with DDL), so I can generate files, and put them straight into SVN. I am using dbm...