Oracle Application Express - Table View Not Ordered

Question

I had created a table; however, every time I insert a row the data does not show up in the order I inserted, any reasons why?

For example,

I inserted rep 20 with all its needed info and so forth, then rep 30, and rep 40.

But the order comes out like this

30
40
20

as opposed to

20
30
40

Thanks in advance.

SELECT * FROM REP; It works fine in Access and everything shows up in order but not in Oracle. — SQL_Student, Nov 09 '14 at 06:52

score 2 · Answer 1 · answered Nov 09 '14 at 07:05

does not show up in the order I inserted

Rows in a relational database do NOT have any "order". Think of them as balls in a basket.

The only (really: the only) way you can guarantee an order when selecting data is to use an order by clause.

score 0 · Answer 2 · answered Nov 09 '14 at 07:06

If you want the results of your SELECT to be in a certain order, you must include an ORDER BY clause. Without ORDER BY, the results can be in any order; it doesn't even need to be in a consistent order.

Assuming that your REP table has a column called id, your query would look like:

SELECT * FROM REP ORDER BY id

Oracle Application Express - Table View Not Ordered

2 Answers2