title: make multiple, composite query in oracle
body: <p>How can i make multiple, composite query in oracle?</p>
  
  <p>for example this several queries in one step?</p>
  
  <p>1</p>
  
  <pre><code>CREATE TABLE test (id NUMBER PRIMARY KEY, name VARCHAR2(30));
  </code></pre>
  
  <p>2</p>
  
  <pre><code>CREATE SEQUENCE test_sequence START WITH 1 INCREMENT BY 1;
  </code></pre>
  
  <p>3</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER test_trigger
  BEFORE INSERT
  ON test
  REFERENCING NEW AS NEW
  FOR EACH ROW
  BEGIN
  SELECT test_sequence.nextval INTO :NEW.ID FROM dual;
  END;
  </code></pre>
  
  <p>4</p>
  
  <pre><code>INSERT INTO test (name) VALUES ('Jon');
  </code></pre>
  
  <p>5</p>
  
  <pre><code>INSERT INTO test (name) VALUES ('Meloun');
  </code></pre>