Your question is not very clear.
You don't need PL/SQL, just
insert into table1(col1,col2,...)
select col1, col2,...
from table2 ...
If this is not what you meant, please read Re: 2. How do I ask a question on the forums?
and follow the advice there.
NOT use inserts with PL/SQL
You can use INSERT INTO <table> (col1,col2,col3 ) select t1.col1,t1.col2 t2.col3 from t1
Thank for your answer.
I am just giving idea. you can try like this...
TYPE l_tab_type IS TABLE OF tablename%rowtype;
BULK COLLECT INTO l_tab
FOR ALL i in 1..l_tab.count
INSERT INTO table2(col1,col2,col3) VALUES(l_tab(i).col1, l_tab(i).col2, l_tab(i).col3);
Why would you want to do that?
That's a much slower and less scalable way than
that I showed earlier.
If your question answered, then please mark your thread as answered, for clear forum, please.