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: Problems with CAST and order by

Re: Problems with CAST and order by

From: Francesco S. Rinaldi <thechessPUSSAVIASPAMMERplayer_at_tin.it>
Date: Thu, 16 Jan 2003 19:30:34 +0100
Message-ID: <b06ton$lcepq$1@ID-136664.news.dfncis.de> 





"DA Morgan" <damorgan_at_exesolutions.com> ha scritto nel messaggio
news:3E26F0FA.BA9FF373_at_exesolutions.com...



> Alias the column to which you have applied the CAST function.

>

> For example:

> select distinct cast(history.object_id as varchar(14)) CASTOBJID

>

> Then order by CASTOBJID

>

> Daniel Morgan

>




It worked !!


Thank you very much, Daniel
Received on Thu Jan 16 2003 - 12:30:34 CST












Original text of this message













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