Re: Insert Order into a table

To achieve what you want, you'll need to add a field to your table, and populate this field with a sequence number (read the doc about sequences if you're not clear) each time you do an insert. This new field should also realistically be defined as the primary key of the table. If your boss or whoever in charge tells you again that adding an extra field is "not an option at this point", then tell him/her that retrieving the records in the same order that they were stored is also "not an option at this point".

Daniel

> 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
Received on Mon Sep 08 2003 - 16:06:22 CEST