I am creating table in oracle database, while adding new row in auto incrementing id table its adding row before previous rows rather than afteras in screenshot.
Asked
Active
Viewed 31 times
0
-
1Possible duplicate of [Default row ordering for select query in oracle](https://stackoverflow.com/questions/899514/default-row-ordering-for-select-query-in-oracle) – Ori Marko May 21 '18 at 07:47
-
Oracle (or any other database in general ) does not guarantee you any specific order of rows retrieved from a select query, unless you have explicitly specified `order by` clause. So, this line is meaningless : "its adding row before previous rows rather than after" – Kaushik Nayak May 21 '18 at 07:49