Re: OCI Problem - HELP
From: Kevin Lukes <klukes_at_novatel.ca>
Date: 10 Mar 1994 23:57:06 GMT
Message-ID: <2loc4i$5bv_at_fw.novatel.ca>
Date: 10 Mar 1994 23:57:06 GMT
Message-ID: <2loc4i$5bv_at_fw.novatel.ca>
John Crupi (jcrupi_at_mystech.mystech.com) wrote:
: But I can't do this :
: Select COUNT( distinct name, division, title ) from company_table;
: I am using OCI.
The problem isn't so much OCI as it is SQL. Count doesn't accept commaseparated fields as an argument. A quick and dirty option is to use concatenation, as in:
SELECT COUNT(DISTINCT NAME || DIVISION || TITLE) FROM COMPANY_TABLE; which should work just well using OCI.
--
===========================================================================
Kevin J. Lukes Programmer/Analyst | klukes_at_novatel.ca
NovAtel Communications Ltd. | (403)295-4573
Calgary, Alberta CANADA | "Opinions expressed are my own"
===========================================================================
Lament of the Unknown Programmer:
What a tangled web we weave, when multiple platforms we conceive
===========================================================================
Received on Fri Mar 11 1994 - 00:57:06 CET