Nonstandard result formatting
From: Krzysztof Dorota <kdorota_at_kruuna.hut.fi>
Date: 21 Nov 1994 17:47:45 GMT
Message-ID: <KDOROTA.94Nov21194745_at_kruuna.hut.fi>
Any help will be appreciated
Date: 21 Nov 1994 17:47:45 GMT
Message-ID: <KDOROTA.94Nov21194745_at_kruuna.hut.fi>
Hello SQL'ers!
Does anyone have a solution for a following problem? I need to format a query result in a "nonstandard" way. Number of tables and rows can not be restricted by the query. I have access to Oracle 6 and 7 .
Example:
DEPT
DEPTNO DNAME --------------- 10 ACCOUNTING 20 RESEARCH 30 SALES
===============
EMP DEPTNO ENAME ------------- 10 CLARK 10 KING 30 ALLEN 30 BLAKE
===============
Desirable result:
DEPTNO DNAME EMPLOYEES ------------------------------------ 10 ACCOUNTING CLARK,KING,... 20 RESEARCH 30 SALES ALLEN,BLAKE,... .. ......... ............
=====================================
Any help will be appreciated
Krzysztof
-- Krzysztof DOROTA ...................... Helsinki University of Technology Administration, Information Systems .. Otakaari 1, SF-02150 Espoo Finland Email: kdorota_at_hut.fi ..... Voice: +358 0 4512012 ... Fax: +358 0 4512993Received on Mon Nov 21 1994 - 18:47:45 CET