tag:blogger.com,1999:blog-2160921736769720124.post3694777230148236512..comments2023-04-29T05:27:41.501-04:00Comments on Absolutely!: Dynamic column ordering and paging in PL/SQLmaxolasersquadhttp://www.blogger.com/profile/05885203204831537402noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2160921736769720124.post-77693988296395525722012-12-14T22:30:48.045-05:002012-12-14T22:30:48.045-05:00I agree. Other SQL databases make this easier. I&#...I agree. Other SQL databases make this easier. I'm not sure why such a simple thing is so difficult in Oracle.maxolasersquadhttps://www.blogger.com/profile/05885203204831537402noreply@blogger.comtag:blogger.com,1999:blog-2160921736769720124.post-67858041572108708332012-12-14T21:06:58.184-05:002012-12-14T21:06:58.184-05:00Thanks for the reply!
So I guess it is just a matt...Thanks for the reply!<br />So I guess it is just a matter of getting used to it. I really think that that should be more programmer-friendly, but if it can't be done any other way, Ctrl+C and Ctrl+V will do :-)Marcushttps://www.blogger.com/profile/17335781577771965007noreply@blogger.comtag:blogger.com,1999:blog-2160921736769720124.post-58558752482723910792012-12-12T20:27:15.620-05:002012-12-12T20:27:15.620-05:00@Marcus: You want to paginate a cursor that is alr...@Marcus: You want to paginate a cursor that is already defined? I'm not sure that can be done.<br />The nice thing about this method is that the outer queries can just be copied-and-pasted and only the inner two queries needs to be changed. The bad thing is that those outer queries are ugly to look at. But once you see them a few times and know to just pay attention to the inner stuff it's not so bad.<br />maxolasersquadhttps://www.blogger.com/profile/05885203204831537402noreply@blogger.comtag:blogger.com,1999:blog-2160921736769720124.post-61042862360609078502012-12-12T20:14:17.870-05:002012-12-12T20:14:17.870-05:00Do you know if there is a way to add pagination ea...Do you know if there is a way to add pagination easily to a query using a cursor? Our code would get ugly really fast if we need to copy and paste two wrappers to every query. We could build the query dynamically using strings, but in this case we would lose all the compile-time type checking that Oracle does...Marcushttps://www.blogger.com/profile/17335781577771965007noreply@blogger.com