Hello All,
I am trying to consolidate and display multiple row data into one. Can you please suggest.
WITH t1 AS
(SELECT 123 SEQ_ID, 'DETROIT' City, to_date('01-JUN-19 00:00:00','dd-mon-rr HH24:MI:SS') start_date, to_date('30-NOV-19 00:00:00','dd-mon-rr HH24:MI:SS') end_date FROM DUAL
UNION ALL
SELECT 123 SEQ_ID, 'Toledo' City, to_date('01-JUL-19 00:00:00','dd-mon-rr HH24:MI:SS') start_date, to_date('30-SEP-19 00:00:00','dd-mon-rr HH24:MI:SS') end_date FROM DUAL
)
SELECT * FROM t1;
Expected output in single row
-----------------------------
SEQ CITY1 START_DATE1 END_DATE1 CITY2 START_DATE2 END_DATE2
---------------------------------------------------------------------------------------------------
123 DETROIT 01-JUN-19 00:00:00 30-NOV-19 00:00:00 Toledo 01-JUL-19 00:00:00 30-SEP-19 00:00:00
Thanks for your time.