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 -> Re: Oracle/SQL - Help

Re: Oracle/SQL - Help

From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Tue, 18 May 2004 17:36:08 GMT
Message-ID: <cQrqc.19951$j6.19721@edtnps84>


Jay wrote:

> All,
>
> I have two fieds defined in a table as follows
>
> prev_val varchar2(200);
> curr_val varchar2(200);
>
> I have following data in that table.
>
> prev_val curr_val
> 19,2 64
> 64 2000
> 9,6 19,2 <<<--- Need to retrieve this row
> 0 9,6
>
> ( comma is the decimal point here )
>
> I need to run a query with where clause like this:
>
> and prev_val <= '10'
> and curr_val > '10';
>
> or
>
> and prev_val <= 10
> and curr_val > 10;
>
> Obiviously the current scenerio won't work? How can I achieve this
> without altering the table?
>
> TIA
>
> J

Apply a TO_NUMBER function to it:
select * from <table> where to_number(prev_val) <= '10' and to_number(curr_val) > 10;

(if I've understood correctly what you are asking for) Received on Tue May 18 2004 - 12:36:08 CDT

Original text of this message

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