SQL Question

From: Johan Locke_at_i-Commerce Services <Locke_at_i-Commerce>
Date: Thu, 4 Jan 2001 09:07:27 +0200
Message-Id: <10730.125675@fatcity.com>

Hi All

Got the following table

DATE 		SEQNO		AREA_FROM	AREA_TO
----		-----		---------	--------
20-JAN	1		LONDON	NEW YORK
20-JAN	2		NEW YORK	ATLANTA
21-JAN	1		LONDON	PARIS
22-JAN	1		NAIROBI	PARIS
22-JAN	2		PARIS		NAIROBI
23-JAN	1		ATLANTA	NEW YORK


Now I need the following report based on the data:
DATE		AREAS				
----		-----				
20-JAN	LONDON - NEW YORK - ATLANTA
21-JAN	LONDON - PARIS
22-JAN	NAIROBI - PARIS - NAIROBI
23-JAN	ATLANTA - NEW YORK

(1) Any Ideas on how to do this report without using Dynamic SQL
(2) Is it possible to write a custom GROUP function in PL/SQL (i.e.,
something that would do a concatenate instead of a sum)?

Kind Regards

Johan Locke

http://www.JohanLocke.co.za
Certified Oracle 8 & 8i DBA
Certified Oracle Developer

Dimension Data i-Commerce Internet Services Direct Line: +27 11 516 5343
mailto:Johan.Locke_at_za.didata.com Received on Thu Jan 04 2001 - 01:07:27 CST