Please, the condition don't filter, Why??????

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Fri, 19 Nov 2004 22:29:55 -0400
Message-Id: <419EAC23.000005.02276@DAZA-MGEJCA5J7T>

Hi I can't filter a query, what I'm doing wrong, please  

This is the query

SELECT TIPO, CTP_COD, CTP_NOMBRE
FROM SOA.VEW_STR_CONTRAPARTE 
WHERE ((CTP_TIPO_CTPTE IS NULL OR CTP_TIPO_CTPTE= 'AGB' )) AND 

(INC_CODCLI_TIT = NVL(NULL,-1) OR INC_CODCLI_TIT IS NULL ) AND INC_TIPO = 'P' AND CTP_COD='CNC';
and it returns all rows from the table ( in thery it only have to return the one that has CTP_COD='CNC'  

The reason is the CTP_TIPO_CTPTE IS NULL , even when it is in parenthesis, it works like a LIKE '%'
Some one understands why?
I suppose this is a bug or is this a misunderstanding of sql. Thanks.  

This is the query
CREATE OR REPLACE VIEW soa.vew_str_contraparte ( tipo,

ctp_cod,
ctp_nombre,
ctp_tipo_ctpte,
inc_tipo,
inc_codcli_tit )

AS
SELECT 'Z' TIPO,'ZZE' CTP_COD, 'EMISOR' CTP_NOMBRE, NULL CTP_TIPO_CTPTE, NULL INC_TIPO, NULL INC_CODCLI_TIT
FROM DUAL
UNION ALL
SELECT 'Z' TIPO,'ZZC' CTP_COD, 'CLIENTE' CTP_NOMBRE, NULL CTP_TIPO_CTPTE, NULL INC_TIPO, NULL INC_CODCLI_TIT
FROM DUAL
UNION ALL
SELECT 'C' TIPO, CTP_COD, CTP_NOMBRE,CTP_TIPO_CTPTE, NULL INC_TIPO, NULL INC_CODCLI_TIT
FROM CONTRAPARTE
UNION ALL
SELECT 'I' TIPO,A.INT_COD CTP_COD,EMP_NOMBRE CTP_NOMBRE, NULL CTP_TIPO_CTPTE  INC_TIPO , INC_CODCLI_TIT
FROM SOA.INTERM A, ADM.EMPRESAS B, INTERM_CTA C WHERE A.EMP_RUC=B.EMP_RUC AND A.INT_COD=C.INT_COD ORDER BY 1,2
/  

Juan Carlos Reyes Pacheco
OCP

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 19 2004 - 20:29:55 CST