1 Reply Latest reply: Apr 16, 2012 1:01 AM by 930477 RSS

    implicit cursors

      hi everyone,
      Implicit cursors are used in dml operations.

      IF i issue a dml st.
      update emp set sal=sal*200;

      A cursor is a pointer and how the pointer reads all the values from result set
        • 1. Re: implicit cursors
          implicit cursor is nothing but DML statement given in the plSql ,
          it functions in the same way as DML statements.
          it will fetch all the records from the DB as a whole.
          it will point to the 1st row of the record.
          then it will process 1 by 1 then.

          u can refer this site also...