Re: How to display 1:Many in a single query
Date: 28 Nov 1994 22:16:01 GMT
Message-ID: <3bdkr1$fc1_at_fred.uswnvg.com>
Nope. Not in SQLPLUS. Use other stuff such as PRO*C, SQL*REPORTWRITER, etc. where you can use cursors. Another option is to use a temporary table where you build up the records and then use another script to print it in SQLPLUS (---YUCK!)
(Whatever I say and own are mine, mine and only mine! So, don't you dare claim they are yours!)
Kim Ng
Paradigm Computer Consulting, Inc.
20611 E Bothell-Everett Hwy SE, Suite 280 Bothell, WA 98012
U.S.A.
Lorrie Gagnon (gagnon_at_dsr.com) wrote:
: I need to return the following data via a single query, if it is possible.
: I haven't had any luck so far.
: Given the classic tables department and employee, list the dept name and
: all employees in the dept as follows:
: Dept Name Employees
: -------------- ------------------------------
: Admin Joe, Sally, Mark
: Programming John, Jill, Jack, Marie
: Mgmt Rick, Kim, Nick
: Is there an easy way to do this with a SINGLE SELECT statement? I'm
: sure I could do it using PL/SQL but that type of interface won't work
: in this case.
: Lorrie Gagnon
: Digital Systems Research
: gagnon_at_dsr.com
Received on Mon Nov 28 1994 - 23:16:01 CET