Whole number pattern matching in Oracle 8i?

From: Keith Lee <cmarvel_at_cts.com>
Date: Wed, 20 Mar 2002 16:27:36 GMT
Message-ID: <3c98b65e.14951719_at_nntp.cts.com>


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 - 17:27:36 CET

Original text of this message