From: anacedent@hotmail.com   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)