Oracle Sort Order - What may cause it to change

view full story

http://stackoverflow.com – Disclaimer: I know that it is bad to not use an 'ORDER BY' in SQL when sorted data is required. I am currently supporting a Pro*C program which is having a wierd-problem. One of the possible causes of the wierd-problem may be that the original developers (from a long time ago) have not used ORDER BY in their SQL even though the program logic depends on it! The program has been working fine all these years and started showing problems only recently. We are trying to pin the wierd-problem to the ORDER BY mistake (there are other cause candidates like a recent port from Solaris to Linux whic (HowTos)