title: Inserting data into table in Oracle 10g
body: <p>I used the following script to create a table in oracle</p>
  
  <pre><code>CREATE TABLE  STAFF_LVL 
     (
      STAFF_LEVEL NUMBER(1,0), 
      MANAGER VARCHAR2(10), 
      OPERATOR VARCHAR2(10), 
      ENGINEER VARCHAR2(10), 
      PRIMARY KEY (STAFF_LEVEL) ENABLE
     );
  </code></pre>
  
  <p>However when I insert the following dat it doesn't work because 2 of the rows are the same</p>
  
  <pre><code>BEGIN
  insert into staff_lvl values (1,'N','N','Y');
  insert into staff_lvl values (3,'N','Y','Y');
  insert into staff_lvl values (7,'Y','Y','Y');
  insert into staff_lvl values (3,'N','Y','Y');
  END;
  </code></pre>
  
  <p>Does anyone know how to solve this?</p>