title: Is there a way to create multiple triggers in one script?
body: <p>I am trying to create multiple triggers with only uploading one script into an Oracle DB / APEX workspace, and running it once.</p>
  
  <p>Here is a brief script compared to the one im trying to use:</p>
  
  <pre><code>    create or replace trigger "BI_TEC_ROLES"   
        before insert on "TEC_ROLES"               
        for each row  
      begin   
        if :NEW."ROLE_ID" is null then 
          select "TEC_ROLES_SEQ".nextval into :NEW."ROLE_ID" from dual; 
        end if; 
      end; 
  
      create or replace trigger "BI_TEC_STATUSES"   
        before insert on "TEC_STATUSES"               
        for each row  
      begin   
        if :NEW."STATUS_ID" is null then 
          select "TEC_STATUSES_SEQ".nextval into :NEW."STATUS_ID" from dual; 
        end if; 
      end; 
  
      create or replace trigger "BI_TEC_SUBS"   
        before insert on "TEC_SUBS"               
        for each row  
      begin   
        if :NEW."SUB_ID" is null then 
          select "TEC_SUBS_SEQ".nextval into :NEW."SUB_ID" from dual; 
        end if; 
      end; 
  </code></pre>
  
  <p>I have tried putting GO in between each individual block, but still only creates the first trigger then gives me an error for the second saying: </p>
  
  <pre><code>    Error(7,1): PLS-00103: Encountered the symbol "CREATE" 
  </code></pre>
  
  <p>I am hoping that it is possible to do this. Thank you very much for your time and interest =)</p>