Re: SQL Question: SELECT statement

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 19 Oct 2001 19:12:16 +0200
Message-ID: <tt0p0mqqgn8g08@corp.supernews.com>

"graaf op wxs" <j.graaf_at_wxs.nl> wrote in message news:9qosc8$7f0$1_at_reader06.wxs.nl...
> Hi all,
>
> Can anyone help me to get the following result from the well known table
> SCOTT.EMP
>
> DEPTNO EMPLOYEES
> ------ ------------------------------
> 10 CLARK, KING, MILLER
> 20 ADAMS, FORD, JONES, SCOTT, SMITH
> 30 ALLEN, BLAKE, JAMES, MARTIN, TURNER ,WARD
>
> Thnx in advance,
> Jan
>
>

You can only do that using PL/SQL
not using SQL only.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 19 2001 - 12:12:16 CDT