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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Helena Markováprogrammer-analystCommented:
The result set in Oracle without ORDER BY is random.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gadsden ConsultingIT SpecialistAuthor Commented:
Ugh. So unless SAP Web Intelligence has some trick up it's sleeve, this won't work.

But thanks!
0
Helena Markováprogrammer-analystCommented:
You are welcome :)
0
Gadsden ConsultingIT SpecialistAuthor Commented:
thanks for the quick reply.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.