[Opensource] How can i do to add limitation position in oracle.

liuhey liuhey at neusoft.com
Tue Nov 18 04:47:27 PST 2003


 In oracle ,we can execute query page by page by this sql : 
 select * from ( select row_.*, rownum rownum_ from ( your query sql ) row_ where rownum <= ?) where rownum_ > ?
This sql has good performance. But I don't know how to configure it in the expresso-config.xml.
Because the limitationPosition element of jdbc can't apply this requirement.



More information about the Opensource mailing list