title: Oracle SQL Developer doesn't put in schema names in trigger DDLs
body: <p>In our test environment, the schema is prepended to the trigger DDL as one might expect.  However, in our QA and PROD environments, the schema prefix doesn't show in the DDL.  We always connect as the "SCHEMA" user so it hasn't been a problem thus far.  Is it worth updating the QA and PROD DDL's to include the schema prefix?  If we don't ever connect to the DB as a user/schema other than "SCHEMA", do we really have anything to worry about?</p>
  
  <p>TEST DDL:</p>
  
  <pre><code>create or replace TRIGGER "SCHEMA"."MDATA_BIR_TRG" 
                  BEFORE INSERT ON "SCHEMA"."METADATA"
                  FOR EACH ROW
                  BEGIN
                    ---CODE HERE.
                  END;
  </code></pre>
  
  <p>QA DDL:</p>
  
  <pre><code>create or replace TRIGGER "MDATA_BIR_TRG" 
                      BEFORE INSERT ON "METADATA"
                      FOR EACH ROW
                      BEGIN
                        ---CODE HERE.
                      END;
  </code></pre>