[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