I am facing a very weird issue on oracle 19.13 version. There was no such issue on oracle 11g.
Query returns more than 10 records and 1 record in between returns crappie value for all the columns, specifically one column data type number(38) primary key column comes with rally very big negative number and that number does not exists in table at all. Application fails with number overflow on that record but if i apply order by to change the row ordering everything works fine.
There is nothing visually anything wrong if I ran same query on oracle SQL developer, no issue at all. It shows 6 digit stored number.