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

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Fri, 19 Nov 2004 22:40:00 -0400
Message-Id: <419EAE80.000009.02276@DAZA-MGEJCA5J7T>

Sorry I miss the example

SQL>            SELECT TIPO, CTP_COD, CTP_NOMBRE
  2               FROM SOA.VEW_STR_CONTRAPARTE
  3        WHERE (CTP_TIPO_CTPTE IS NULL OR CTP_TIPO_CTPTE= 'AGB' ) AND
  4              (INC_CODCLI_TIT = NVL(NULL,-1) OR  INC_CODCLI_TIT IS NULL )

AND   5 INC_TIPO = 'P' AND CTP_COD='CNC'   6 ;

T CTP CTP_NOMBRE

- --- --------------------------------------------------

C ABB BBA VALORES AGENTE DE BOLSA S.A.
C BBC AGENCIA DE BOLSA BANCRUZ S.A.
C BCB BANCO CENTRAL E BOLIVIA
C BIA BISA AGENCIA DE BOLSA S.A.
C CAI COMPAŠIA AMERICANA DE INVERSIONES S.A. C CBA CREDIBOLSA S.A.
C CSB CITICORP SECURITIES BOLIVIA S.A.
C MIB MERCANTIL INVERSIONES BURSATILES S.A. C NEW NUEVA AGENCIA
C NVA NACIONAL DE VALORES S.A.
C PAN PANAMERICAN SECURITIES S.A.
C PRO PROBOLSA S.A.
C SAX SAXXON CAPITAL S.A.
C SER SUDAMER VALORES S.A.
C SUD SUDAVAL S.A.
C VLP VALORES BURSATILES LA PAZ S.A.
C VUN VALORES UNION S.A.
I CNC CANACORD SA 18 filas seleccionadas.

SQL>

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

Received on Fri Nov 19 2004 - 20:42:03 CST