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.

Member Avatar for hfx642

(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 for hfx642

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 for hfx642

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.