Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with simple SQL query!

Re: Problem with simple SQL query!

From: Tom Sager <tom.sager_at_lgeenergy.com>
Date: 1998/09/30
Message-ID: <MPvQ1.3417$rm3.2059206779@news.ntr.net>#1/1

<<When I remove the ORDER part of the statement it runs fine but the ORDER is essential. Can anyone help on this one?>>

This is because an ORDER clause is not valid in a subquery. Why is order important to you? Your statement is merely inserting rows into a table. The order in which rows are inserted into a table hasn't much significance. The order in which you insert rows does not guarantee the order in which they will be retrieved.

When you are ready to SELECT rows from the inserted table, you can order them any way you want with an ORDER BY. Received on Wed Sep 30 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US