Fetch record from cursor and bulk insert in table

Fetch record from cursor and bulk insert in table

CREATE TABLE MYTEST
(    �OBJECT_NAME� VARCHAR2(128 BYTE),
�OBJECT_ID� NUMBER,
�CREATED� DATE
);

TYPE myrecord_tab_type IS TABLE OF MYTEST%ROWTYPE;
myrecord_tab myrecord_tab_type;

FETCH ref_cursor BULK COLLECT INTO myrecord_tab;

FORALL i IN 1 .. myrecord_tab.count
INSERT
INTO mytest
VALUES myrecord_tab(i);

download file now