http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+reuse+SQL-fragments
On Mon, Nov 23, 2009 at 9:11 AM, Stephen Friedrich <stephen.friedr...@fortis-it.eu> wrote: > My application uses a lot of "manual" paging (using ROWNUM and nested selects > in Oracle PL/SQL). > For each of these queries there is a second query that returns the total > number of results with _identical with-clause_ (sometimes quite complex). > Does iBatis offer any help in avoiding these code duplicates? > > (Or does anybody know a better way, for example a way to retrieve both the > total count and a specific "page" in a single statement?) > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
