Building sql statement for CREATE_GROUP_FROM_QUERY

From: <wozi_at_dhc.net>
Date: Thu, 27 Jan 2000 14:11:24 -0800
Message-ID: <4028CFB195FA523F.40C022AE6A52E6D9.7B6B20D9D9FF9D5E_at_lp.airnews.net>

I am using the sample scott.dept table.

I want to construct the sql statement such that the ouput in the t-list looks like
example 1 and NOT example 2

group_id=CREATE_GROUP_FROM_QUERY( ' list_element' , 'Select .........' )

example 1

---

10  ACCOUNTING     NEW YORK
20  RESEARCH        DALLAS
30  SALES                 CHICAGO
40  OPERATIONS     BOSTON

example 2

---

10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON thanks for your assistance Received on Thu Jan 27 2000 - 23:11:24 CET