8 Replies Latest reply: Apr 28, 2013 10:46 AM by GregorM RSS

    sum of sal and comm in emp table

    makdutakdu
      hi all

      for the table emp with fields enam,eno,dept,sal,comm

      i want to display a field in oracle forms 6i that will show me sum of sal and comm

      i created a non database field
      and wrote this code in the formula
      declare
      summ number(10);
      begin
      
      summ=:sal + :comm
      end;
      but i get failed compilation

      kindly guide

      thanking in advance