Thanks for the question, TomazD.
Asked: March 31, 2021 - 12:28 pm UTC
Last updated: April 12, 2021 - 5:22 am UTC
Viewed 100+ times
rather basic question.
Does database guarantee to return rows from external table, OS file, in the same order as they are positioned in file.
I am well aware that only proper order by clause can achieve this. But we have some 10+ years old database job which was migrated from 10.2 to 11.2 to 12.2 during these years and it was always returning rows in order of external file till version 12.2.
External table is joined to two other tables but sql is without order by clause.
and we said...
No - as with any query, the only want to guarantee rows return in a particular sequence is to use order by!