Hi,

I want do pagination per page show only 25 records.
Here is fetching data is too large and there I can't use
rownum for that.

in fetching data there is no any unique column.

so tell me how can do it?

Thnaks in advance.

Recommended Answers

(It seems that I've seen this question before.)
What are you using?
If you are using Oracle Forms, it will take care of this automatically.

Jump to Post

Okay... In that case, Look up CURSORs.
You can loop through record by record.

Jump to Post

All 5 Replies

Member Avatar

(It seems that I've seen this question before.)
What are you using?
If you are using Oracle Forms, it will take care of this automatically.

I am using for that plsql/oracle

Member Avatar

Okay... In that case, Look up CURSORs.
You can loop through record by record.

Hi,

actually here problem is I have too large data and for fetching required too much time so I want to remove time for fetching data so tell me how can it will be possible.

please help me ...... I am waiting reply.......

Member Avatar

If you've got THAT many records to process,
how about archiving some of the older records so you have few records to search through.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.