The table A 10th,20,30,40,50,...> 100 w lines of data in the table B,

CodePudding user response:

This kind of query, the relevant data is the best way to the line, copy into an internal table, then according to the query,

CodePudding user response:

All found out, and then find the line,

CodePudding user response:

Declare
i number;
The begin
I:=10;
For c1 (in
Select * from A where rownum=I
)
Loop
- SQL statement
Exit the when i>=1000
I:=I + 10;
End loop;

end;