Re: Order by queries against INSERT statements from procedures

Friday, December 10, 2004, 6:31:51 AM, Jose Manuel Quesada (jose.manuelquesada_at_gmail.com) wrote:

JMQ> 2.- If I have the INSERT statement within a procedure, each time I run
JMQ> the procedure, the "order by" query may return a different sequence of
JMQ> ordered rows sharing the same DATE_OPER, DATE_FIFO values.

JMQ> Any idea about this behaviour?

Is there some third column you wish to sort on? Otherwise, there's no reason not to expect results like:

DATE_OPER DATE_FIFO SOME_OTHER_COLUMN
11/1/01 11/1/01 A
11/1/01 11/1/01 B

one time, and results such as:

DATE_OPER DATE_FIFO SOME_OTHER_COLUMN
11/1/01 11/1/01 B
11/1/01 11/1/01 A

another time.

Don't look for consistency in row order beyond that which you specify in your ORDER BY clause.

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body.

--
http://www.freelists.org/webpage/oracle-l