2 Replies Latest reply: Sep 23, 2013 9:59 AM by Mike Kutz RSS

    There's an INSERT block in my procedure whose Syntax in completely unknown to me.

    madhulekhamazumder

      The INSERT block  here :

       

      INSERT INTO employee

      DELETE FROM employee;

       

           (EMPID,

           EMPNAME,

           EMPSALARY,

           DEPT,

           LOCATION,

      SELECT EMPNO,

           ACCOUNTNO,

           COUNTRY,

           DC)

           NAME,

           SAL,

           DPTMT,

           STATION    

      FROM stats

      WHERE DATE=SYSDATE;

       

       

      I do not know how the script is working.i am unaware of the syntax as well. the absence of VALUES clause,abrupt start n close brackets etc. confusing me.

      this might be one of the ways to write INSERT,please enlighten if u can.