Please .. i need help..!

[Karina Gámez]

Hi,,

Anybody can please tell me how can i bring data from a "x" table... using fetch.. or something like that..

I work with a lot of information... so.. i need to bring data for example... 1 to 100 records.. and then.. 105 to 200 .. etc...

thanks a lot..

[srinika]

I'm not sure about ur data structure (ie. how do u identify 1 to 100 records.. and then.. 105 to 200 .. etc...).
Either u have to have some identification on the record number or some identification of the data one or more data fields
Any way u can use SQL statements.
Also note that the SQL may slightly vary depending on the Database u use.
The following statement may be wrong since I didn't write any Oracle PL SQL in the recent past, but is of the similar format:
Select * from x where RecordNumber > 105 and RecordNumber < 200 or
Select * from x where RecordNumber > 105 and RowCount < 200
* In the above RecordNumber / RowCount are database depending variables (ie. not our field names)


Srinika