Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

2
  • The order should not matter, since rows in a table in oracle are not inherently ordered. When data is selected from the table, the ORDER BY clause in the SELECT statement determines in what order the data is represented. If no order by clause is set, the order is indeterminate Commented Nov 26 at 13:53
  • @KoenLostrie, the table is empty at first. During the execution, I select the table select max(date) from table and the result is the last date, it must show the first date and then increments but I see the to_date ! Commented Nov 26 at 14:01