From: kennedy-down_with_spammers@no_spam.comcast.net   
      
   "traceable1"  wrote in message   
   news:8551d8c9.0309051255.2a56c9b0@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:   
   >   
   >              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   
      
   You should ask for the data in the order you want it.  doing a commit after   
   each statement is going to slow things down.(and doesn't have anything to do   
   with what you aretrying to accomplish).  The problem is that you fail to   
   grasp that sql (structured query language) is a set based language and how   
   the data is stored in the table is irrelevant to the order you put it in.   
   You need to specify the order of the data in the set you ask for and sql   
   will return it in that order. eg select * from mytable order by 1;   
      
   for more information read up on Codd and get a better understanding.  We are   
   not dealing with a file based system but a RDBMS.   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)