Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Whole number pattern matching in Oracle 8i?
Have you tried using the FLOOR or ROUND functions to strip out the decimal places?
Keith Lee wrote:
> All:
> I am attempting to do a total count on a database table's information. I am counting on a whole number based on
> whether two other numbers are equal or not. These other numbers are of the definition number(5,2). I trying not to
> count the numbers that aren't a whole number. That is if the data were:
>
> 1
> 1.2
> 2
> 2.4
> 2.5
> 3
>
> Here I am trying to count only the numbers 1, 2, 3. How would I do that in Oracle 8i Personal Edition?
>
> Keith Lee
Received on Wed Mar 20 2002 - 10:43:25 CST