News

CURSOR - pointer to a memory area called context area. Context area is a part of memory inside the process global area (PGA). Context area holds important information about DML statements such as.
1.Create employee table with following attributes (empid NUMBER, empname VARCHAR(10), dept VARCHAR(10),salary NUMBER); 2.Create a cursor named as employee_cursor 3.Using cursor read each record and ...