Re: Insert Order into a table

traceable1 wrote:
> 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:
>
> 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
>
>
> 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

Oracle does not work the way you expect/desire it to work. Received on Sat Sep 06 2003 - 03:00:38 CEST