Skip to Content
0
Jun 11, 2009 at 12:00 PM

For all entries against Ranges

1022 Views

Hi,

I have a question regarding a Select query where I have to select some data and then store it in table and refer it for the 2nd Select.

eg: Select from table 1

into itab1.

select from table 2

into itab2

for all entries in itab1.

My question is should I use a Range for the 1st select instead of an itab.The itab1 will be containing max 50 records.

The problem with for all entries is that I cannot use 'UP TO ROWS' as it only deletes extra entries at application level and not database level. I will be selecting 1000 rows even if I want only 100 rows.

Please let me know ur views