Home » SQL & PL/SQL » SQL & PL/SQL » Pagination (Merged)
Pagination (Merged) [message #227681] Thu, 29 March 2007 00:49 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hai

I want to known pagination Query.
Any body help me pls..

regards,
Arun Razz
Re: pagination query [message #227686 is a reply to message #227681] Thu, 29 March 2007 01:12 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
After searching for 'pagination' on AskTom:
link
link
link

Or you may search yourself to get another 200+ links.
display every 10 records of total 1000 rec. [message #227695 is a reply to message #227681] Thu, 29 March 2007 01:37 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member


hai,

i had 1000s of records from database

i have to display the records 10 by 10(pagination)

Any body?

Regards,
Arun. Laughing



Re: display every 10 records of total 1000 rec. [message #227696 is a reply to message #227695] Thu, 29 March 2007 01:38 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Look, we do know what pagination is. No need to create a new topic for that.
Re: display every 10 records of total 1000 rec. [message #227800 is a reply to message #227696] Thu, 29 March 2007 07:36 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Arun,
I've deleted the third thread addressing the exact same issue. No matter how often you start a thread about pagination in Oracle, the answer will be the same:
  • Read the links provided by flyboy
  • Search the board
  • Read the FAQ pages.


But I'd start from asktom.oracle.com. Tom Kyte explains this issue in a very clear way. He even published it in Oracle Magazine.

If you still have problems with it, post your query here (don't forget to use code tags to increase readability) and we'll have a look at it.

MHE
Previous Topic: significance of count(1)
Next Topic: Help on subquery
Goto Forum:
  


Current Time: Sun Dec 04 08:23:27 CST 2016

Total time taken to generate the page: 0.11560 seconds