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: SQL Query

Re: SQL Query

From: Nat <natalia.poggi_at_spm.com.ar>
Date: 1 Oct 2003 12:49:56 -0700
Message-ID: <1155e81c.0310011149.18cf1212@posting.google.com>


Is the datatype of the field string??
How would you like the query to show "1,3/3,0/30,0/2,1/4,2", provide an expample

penghao98_at_hotmail.com (Leon) wrote in message news:<89a0a7de.0310010657.54ac116d_at_posting.google.com>...
> Hi,
>
> I have a database table contains a field that has date like
> 1,3/3,0/30,0/2,1/4,2 , and I am trying to make a sql query to query
> out this record if two numbers seperated by comma, left side is equal
> to 1 and right site is greater than 0. Is it possible? if so, how can
> I do it?
>
> Thank you very much for your help.
Received on Wed Oct 01 2003 - 14:49:56 CDT

Original text of this message

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