A simple example on how to sort a HTML table with the jQuery table sorter plugin. Also describes how to automatically scroll the browser with the jQuery scroll to plugin.

Today I was working on a data table, output in HTML generated by PL/SQL and I needed to implement a feature that would allow the user to sort the table based on the column header they clicked on.

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.

You might have been in a situation before where you had a list of items in your database that needed to be output in a specific order. These items could be anything: perhaps a listing of your favourite movies or your favourite books.