PL- SQL Pagination and Sorting Example

Top Tutorials

New Tutorials

Submit

Login

Register

Tutorial Detail

• Total Hits: 5648

• Average Rating :
  

•  

• Total Votes: 41 votes

• Category: Oracle/Oracle Misc

• Submitted on: 2008-04-15 01:59:41

• Submitted By: Shekhar

• Set as Favorite

Description:

I've put together a comprehensive example for paginating and sorting a table of data in a web page using PL/SQL. This example uses the all_objects table, so should be usable on any Oracle database. It is fully commented and should be pretty self-explanatory. The example uses two small images for the column sorting links, asc.gif and desc.gif. You should put these wherever you store your images and update the code to reflect that location.    More detail...

Rating Detail

Stars	Percentage	Total Vote
	17.07%	7
	17.07%	7
	14.63%	6
	14.63%	6
	21.95%	9

Caste Your Vote

Rating	Selection	Guidelines
Poor:		Very disappointing, useless.
Fair:		Below average, disappointing but not useless.
Good:		About average in its class.
Very Good:		Above average for its category.
Excellent:		One of the best Tutorials in its category.

---