title: Oracle 'statement level' Trigger
body: <p>I want to create a Statement level Trigger which means I want to insert only one record into table EMP_AUDIT when 1 or more rows are inserted into table EMP. For example: if I have 10 records inserted into EMP, then only 1 record should be inserted into EMP_AUDIT table.</p>
  
  <p>There are no constraints on columns. (i.e. can be NULL)</p>
  
  <p>I tried to use the following trigger but it gives me the Error(2,2): PL/SQL: SQL Statement ignored
  Error(2,14): PL/SQL: ORA-00947: not enough values</p>
  
  <pre>
     CREATE OR REPLACE
      TRIGGER TRIG_EMP AFTER INSERT ON EMP
     BEGIN
      INSERT INTO EMP_AUDIT
      VALUES (TRANID,EMPNUM,SYSDATE); 
     END;
  </pre>
  
  <pre>
     CREATE TABLE EMP
     (TRANID NUMBER,
      EMPNUM VARCHAR2(100),
      EMPLOC VARCHAR2(100)); 
  </pre>
  
  <pre>
     CREATE TABLE EMP_AUDIT
     (EVENTID NUMBER,
      EMPNUM VARCHAR2(100),
      ENTRDATE DATE); 
  </pre>