DataTables, the Server Side Option & Oracle
DataTables, the Server Side Option & Oracle
tinker1123
Posts: 22Questions: 0Answers: 0
I've been cobbling code for the server side processing option for DataTables to get around the poor performance of IE 8.
I discovered that Oracle 11g lacks the keyword "LIMIT" that is used by other systems for paging results ( i.e. getting records 20 - 30 out of 100 records ).
I found this stackoverflow post and the comments underneath it to be so helpful in coming up with a workaround that I thought others here might find it useful.
HTH
Steve
http://stackoverflow.com/questions/470542/how-do-i-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering
I discovered that Oracle 11g lacks the keyword "LIMIT" that is used by other systems for paging results ( i.e. getting records 20 - 30 out of 100 records ).
I found this stackoverflow post and the comments underneath it to be so helpful in coming up with a workaround that I thought others here might find it useful.
HTH
Steve
http://stackoverflow.com/questions/470542/how-do-i-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering
This discussion has been closed.