DECLARE CURSOR C IS SELECT * FROM tbinstrument; BEGIN FOR CV IN C LOOP INSERT INTO tbnseinstrument VALUES(CV.ins_id,CV.ins_name); END LOOP; END; /
DECLARE c CURSOR FOR SELECT * FROM tbinstrument;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)