Fw: Please, the condition don't filter, Why??????
- From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Nov 2004 22:40:00 -0400
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>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Fw: Please, the condition don't filter, Why??????
