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

Home -> Community -> Usenet -> c.d.o.server -> Order by with case unsensitive in UNION

Order by with case unsensitive in UNION

From: Xavier Arques <Xavier.Arques_at_alcatel.fr>
Date: Mon, 04 Jan 1999 11:59:53 +0100
Message-ID: <36909F29.90F67262@alcatel.fr> 





I'm trying to sort datas in an UNION with case unsensitive:



SELECT address1 from A


UNION



SELECT address2 from B


ORDER BY LOWER(1)


but it doesn't work.



Can some one tell me how to do  ?


Received on Mon Jan 04 1999 - 04:59:53 CST












Original text of this message













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