Oracle Stored Procedure Loop insert a table to another table

Oracle Stored procedure Loop insert a table to another table 1. create a Stored procedure SQL code create or replace procedure inserttest as cursor cs is SELECT sales_id FROM t02salesinfo_backup; sales_id varchar (128 ); begin for c in cs loop BEGIN insert into gf_target_personaltarget (USER_ACCOUNT_ID, PERSONAL_VFYP) values (c. sales_id, '200'); END; end loop; end inserttest; 2. Clear the SQL code of the table you want to insert data into. truncate table gf_target_personaltarget; 3. Execute the Stored Procedure SQL code call I on the command line Nserttest (); ------- here there are Parentheses, parameters also need to be passed! Commit;