Insert Order into a table
Date: 5 Sep 2003 13:55:34 -0700
Message-ID: <8551d8c9.0309051255.2a56c9b0_at_posting.google.com>
I am inserting data rows into a table via a stored procedure. After
the inserts, I query the rows in the table and I want them to spit
back out in the same order I put them in.
However, apparently, Oracle actually inserts the rows in some type of
bulk insert, so they are not in the same order I put them in. I run a
COMMIT after each insert, to no avail.
Here's kind of an example of what I'm talking about:
How can I force Oracle to put these rows in the table correctly?
(and, probably, less efficiently, but I don't care).
I realize this table needs some sort of KEY column, but that is not an
option at this point.
Thanks in advance to anyone who can help!!
traceable
INSERT into mytable ('A'); COMMIT;
INSERT into mytable ('B'); COMMIT;
INSERT into mytable ('C'); COMMIT;
INSERT into mytable ('D'); COMMIT;
SELECT * FROM mytable;
B
C
A
D