Quiero obtener los ids de una tabla en una sola fila y separado por |
SELECT SUBSTR (SYS_CONNECT_BY_PATH (CAMPO, '|'), 2) CONCATENADO
FROM (SELECT CAMPO, ROW_NUMBER () OVER (ORDER BY CAMPO) rn,
COUNT (*) OVER () cnt
FROM nombre_tabla)
WHERE rn = cnt
START WITH rn = 1
CONNECT BY rn = PRIOR rn + 1;
FROM (SELECT CAMPO, ROW_NUMBER () OVER (ORDER BY CAMPO) rn,
COUNT (*) OVER () cnt
FROM nombre_tabla)
WHERE rn = cnt
START WITH rn = 1
CONNECT BY rn = PRIOR rn + 1;
