title: inserting trigger on same table after insert
body: <pre><code>CREATE TABLE STUDENTS_1
  (
  NAME VARCHAR2(50)NOT NULL,
  DIV VARCHAR2(5) CHECK (DIV IN ('E','F','G')),
  MARKS NUMBER CHECK (MARKS &lt;= 600),
  GRADE VARCHAR2(5) CHECK (GRADE IN ('A','B','C'))
  )
  </code></pre>
  
  <hr>
  
  <pre><code>CREATE OR REPLACE TRIGGER MARKS 
  BEFORE INSERT OR UPDATE ON STUDENTS_1
  FOR EACH ROW 
  
  
  BEGIN
  
  IF (:NEW.MARKS&gt;500)THEN 
  INSERT INTO STUDENTS_1(MARKS,GRADE)VALUES(:NEW.MARKS,'A');
  
  ELSIF (:NEW.MARKS&gt;400 AND:NEW.MARKS&lt;500) THEN 
  INSERT INTO STUDENTS_1(MARKS,GRADE)VALUES(:NEW.MARKS,'B');
  
  ELSE (:NEW.MARKS &lt;400 )
  INSERT INTO STUDENTS_1(MARKS,GRADE)VALUES(:NEW.MARKS,'C');
  
  
  END IF ;
  END;/
  </code></pre>
  
  <p>I would insert marks into this table and i want trigger to trigger grade accordingly into the same table with respect to what marks i'm entering and  i'm getting <code>not enough values error</code> when i'm doing this 
  So i wanted to know that what i'm doing is it possible or there's another way ??</p>