Re: Beginning and end of table
Thanks for response.
You say: To order row display, use queries with Order By clauses, optimise them correctly for performance, use Where or Limit clauses to paginate, and write code to keep track of which row the user is in her browsing.
I do all of that in addition to ordering the table with alter as backup. When I
select the next row based say on lastname and include order by, I assumed the oder by applied to the returned dataset. in my cast this is one so I don't see how using the order by clause is relevant in that context.
Subject
Views
Written By
Posted
1059
March 28, 2018 12:24PM
558
March 28, 2018 01:07PM
674
March 28, 2018 05:13PM
698
March 28, 2018 08:35PM
Re: Beginning and end of table
687
March 29, 2018 06:05AM
564
March 29, 2018 06:34AM
664
March 29, 2018 07:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.