title: Generating DDL script for object without schema name baked in using DBMS_METADATA.GET_DDL?
body: <p>How can I generate the DDL script for my object with <code>DBMS_METADATA.GET_DDL</code> without the schema name baked in?</p>
  
  <p>With <code>DBMS_METADATA.GET_DDL</code>:</p>
  
  <pre><code>CREATE TABLE "MYSCHEMA"."MYTABLE"
  (
    "COL1"  NUMBER(10,0)
  )
  </code></pre>
  
  <p>SQL Developer can do that, and I think it's also uses the DBMS_METADATA to achive this goal and generale DDL scripts.</p>
  
  <p>With SQL Developer:</p>
  
  <pre><code>CREATE TABLE "MYTABLE"
  (
    "COL1"  NUMBER(10,0)
  )
  </code></pre>