PL- SQL Pagination and Sorting Example

Tutorials Shared by the Internet Community

Advertisements


Synopsis

I have put together a comprehensive example for paginating and sorting a table of data in a web page using PL/SQL.

Statistics

  • Total Hits - 27874

  • Total Votes - 184 votes

  • Vote Up - 65 votes

  • Vote Down - 119 votes

  • Domain - joelennon.com

  • Category - Oracle/Oracle Misc

  • Submitted By - Shekhar

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

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. ...


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements