I am using the OCI functions to run a rather large query. I want to sort the results by 4 different criteria. When I run this query just against the database it comes back fine. But when I run it using php and OCI, it seems to ignore my ORDER BY command. Is there a limit to the number of ORDER BY elements you can have? My ORDER BY looks like this
Code: Select all
order by SITE, PG, GROUPNAME, rank, SKU
It seems to order by sku before ordering by rank. Any ideas?