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: Queries give impossible results

Re: Queries give impossible results

From: Jake S <nospam_at_nospam.net>
Date: Fri, 15 Nov 2002 05:58:27 GMT
Message-ID: <720B9.20$Ph.877@read2.inet.fi>


>
> What happens when you try
>
> SELECT count(*) FROM ci_customer WHERE customer_state <> 'ACTIVE' AND
> customer_type = 'PERSON';
>
> -- rajXesh

SQL> SELECT count(*) FROM ci_customer WHERE customer_state <> 'ACTIVE' AND customer_type = 'PERSON';

  COUNT(*)


         0

Received on Thu Nov 14 2002 - 23:58:27 CST

Original text of this message

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