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 -> Why ORA-01785 ORDER BY item must be the number of a SELECT-list expression?

Why ORA-01785 ORDER BY item must be the number of a SELECT-list expression?

From: Poon Chak Yau <cy_poon_at_ctil.com>
Date: 1997/07/17
Message-ID: <33cd8dba.89083649@news.hkstar.com>#1/1 







Hello,


        I have an union statement that have an order-by clause.
However, I get error ORA-01785. Do you know why it requires me to
specify the order by column number instead of column name? In fact,
why Oracle ask for that? Is there any situation that column name is
not possible?



Regards,
Received on Thu Jul 17 1997 - 00:00:00 CDT












Original text of this message













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