Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> select distinct does not work on Oracle 8i

select distinct does not work on Oracle 8i

From: Bernd Rosenau <brosenau_at_gss-online.de>
Date: Thu, 12 Oct 2000 14:42:02 +0100
Message-ID: <jsfbus8nmfa2pa7lmgmt2fv8au8kpg4vcd@4ax.com> 







Hello,



our application is programmed in VB 6 and connects to an Oracle
database


using ADO. The following statement submitted from the client works ok
if the backend is Oracle 8.0.5 but it is giving non-distinct results
when the backend is Oracle 8i.



SELECT DISTINCT Bereich FROM GenericTable



What can i do ?



Many thanks in advance for your help,



Regards, Bernd
Received on Thu Oct 12 2000 - 08:42:02 CDT












Original text of this message













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