May 19, 2010 | In: coldfusion, oracle, paging
I learned something new today. Using ROWNUM in an Oracle query, while it does limit the resultset to the number specified, does not limit it to the top n results. It’s basically a random sample because it appears that ROWNUM is calculated...
February 25, 2010 | In: coldfusion, oracle
Figured this one out by sheer, dumb luck. driverManager = createObject("java","java.sql.DriverManager"); conn =...
Ok, I just learned how to do levels and partitioning in an Oracle query today, and I have to say it's pretty cool. Basically, I have a view that returns groups of data; i.e. multiple rows with matching "key" attributes but different non-prime...