PLSQL statement cycle data was made in A table, A table of field 1 need to take all values in the table field 2 B, how to realize circulation in table B field, thank you

CodePudding user response:

The original poster, for example, can use excel to draw once, what is your original data, hope that the result of what is,

CodePudding user response:

The begin
For the rr (select in p2 from b)
Loop
The execute immediate 'insert into a (p1) values (' | | rr. P2 | |');
end loop;
end;

CodePudding user response:

refer to the second floor to learning turn response:

begin
For the rr (select in p2 from b)
Loop
The execute immediate 'insert into a (p1) values (' | | rr. P2 | |');
end loop;
end;

??

CodePudding user response:

refer to the second floor to learning turn response:

begin
For the rr (select in p2 from b)
Loop
The execute immediate 'insert into a (p1) values (' | | rr. P2 | |');
end loop;
end;

solved, the method on the second floor

CodePudding user response:

reference 1st floor selling fruit net reply:

the original poster, for example, you can use excel to draw once, what is your original data, and hope that the result of what is,

solved

CodePudding user response:

reference 5 floor weixin_39466567 reply:

Quote: refer to 1st floor selling fruit net reply:

the original poster, for example, you can use excel to draw once, what is your original data, and hope that the result of what is,

solved

Yes, it is good to solve the,