What is the sort order of Oracle data, without a specific ORDER BY

I am using SAP Business Objects Web Intelligence, they have a nice feature call LAST, which simply returns "the last value in a data set". I tested this out and at first it looked good, but then I found a case where it wasn't returning the logical "Last".  It DOES return the LAST record of the data set, as returned by Oracle.

When you write a query in Web Intelligence, Order by is not specified, it just returns everything in whatever order Oracle does, then you sort it in Web Intelligence.

Here's the data set returned by Oracle. It's not sorted by the date of the records entry, so then what is the logic? It doesn't look I can use the Web Intelligence function LAST.
Oracles raw data set, no logical order
Gadsden ConsultingIT SpecialistAsked:
Who is Participating?
Helena MarkováConnect With a Mentor programmer-analystCommented:
The result set in Oracle without ORDER BY is random.
Gadsden ConsultingIT SpecialistAuthor Commented:
Ugh. So unless SAP Web Intelligence has some trick up it's sleeve, this won't work.

But thanks!
Helena Markováprogrammer-analystCommented:
You are welcome :)
Gadsden ConsultingIT SpecialistAuthor Commented:
thanks for the quick reply.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.