Concat of two fields in different rows - ORACLE

Question

Concat of two fields in different rows - ORACLE

Navigation

#1 by (0 votes)

2

I have the table Adjudicacion which carries various data, including no_garantia , and each row of the query would be an adjudication. Each award, as I said before, has its kind of guarantee (normal, professional or both). If the award has both types of guarantee, the query gives me two identical rows except in no_garantia . What I want is that I only get one award instead of two, but in that allocation I get in the field no_garantia a concatenation of the two fields no_garantia of each identical row. I tried to make a group by Adjudicacion.ID , since the allocations are identical in ID too, but then I would not know how to gather the data of the two rows in a field ...

 SELECT 
        PPR_ADJUDICACION_M.ID, PPR_ADJUDICACION_M.NU_PROCESO,
PPR_ADJUDICACION_M.NO_PROCESO, PPR_ADJUDICACION_M.NU_IMPORTE, 
    PPR_ADJUDICACION_M.ID_TIPO_RIESGO, PPR_ADJUDICACION_M.ID_MONEDA, PPR_ADJUDICACION_M.ID_SUBGRUPO_PRODUCTO, PPR_ADJUDICACION_M.ID_ESTADO, PPR_ADJUDICACION_M.ID_SUBESTADO, 
    PPR_ADJUDICACION_M.ID_TIPO_COMPRA, PPR_ADJUDICACION_M.FT_ADJUDICACION, PPR_ADJUDICACION_M.ID_CONTACTO, PPR_ADJUDICACION_M.ID_PETICIONARIO, 
    PPR_ADJUDICACION_M.FT_INICIO_CONTRATO, PPR_ADJUDICACION_M.FT_FIN_CONTRATO, PPR_ADJUDICACION_M.FT_CAMBIO_ESTADO, PPR_ADJUDICACION_M.FT_CAMBIO_SUBESTADO, 
    PPR_ADJUDICACION_M.NU_RECORDATORIOS_ENVIADOS, PPR_ADJUDICACION_M.ID_PROVEEDOR,
    PPR_ADJUDICACION_M.IN_GLOBAL, PPR_ADJUDICACION_M.IN_CONFORME,PPR_ADJUDICACION_M.IN_CONFIDENCIAL,PPR_ADJUDICACION_M.IN_COMPRA_CONDIC,PPR_ADJUDICACION_M.IN_ACCION,
    PPR_ADJUDICACION_M.TX_OBSERVACIONES, PPR_ADJUDICACION_M.TX_OBS_ESTADO,
    PPR_ADJUDICACION_M.IT_VERSION, PPR_ADJUDICACION_M.FT_USU_MOD, PPR_ADJUDICACION_M.FT_USU_ALTA, PPR_ADJUDICACION_M.IN_BAJA, PPR_ADJUDICACION_M.NO_USU_ALTA, PPR_ADJUDICACION_M.NO_USU_MOD,PPR_ADJUDICACION_M.NO_GARANTIA 
            FROM PPR_ADJUDICACION_M 
            where PPR_ADJUDICACION_M.ID_VERSION = 3101
        group by PPR_ADJUDICACION_M.ID

sql oracle concat

asked by Richard Sánchez Coliao 09.08.2018 в 15:00

source

1 answer

MySQL table creation methodology for repeated values Error in Laravel Routes 5

score 0 · Answer 1

You must use the CONCAT() function for the fields you want to join.

The CONCAT () function concatenates two or more expressions into one.

    SELECT otros campos... 
           CONCAT(PPR_ADJUDICACION_M.NO_USU_MOD,PPR_ADJUDICACION_M.NO_GARANTIA) as no_garantia 
                FROM PPR_ADJUDICACION_M 
                where PPR_ADJUDICACION_M.ID_VERSION = 3101
            group by PPR_ADJUDICACION_M.ID

I leave you the documentation .