| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: Queries give impossible results
>
> 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
![]() |
![]() |