Master - Detail Report From SQLPLUS

From: Tom Tiplady <ttiplady_at_specialtysystems.com>
Date: 1997/03/21
Message-ID: <01bc3609$6a62d9c0$65efb4cc_at_tiplady.specialtysystems.com>#1/1

[Quoted] Is there an easy way to construct a master detail report in SQLPLUS. There is one master table and two child tables. Report would look like

Master1 XXXXXXXXX

	Detail 1  XXXXXXXXX   XXXXXXXXXXX
	Detail 1  XXXXXXXXX   XXXXXXXXXXX
	Detail 2  XXXXXXXXX   XXXXXXXXXXX
	Detail 2  XXXXXXXXX   XXXXXXXXXXX

Master1  XXXXXXXXXX 
	Detail 1  XXXXXXXXX   XXXXXXXXXXX
	Detail 1  XXXXXXXXX   XXXXXXXXXXX
	Detail 2  XXXXXXXXX   XXXXXXXXXXX

Is this better suited for PL/SQL?
[Quoted] I also need output to go to an ASCII file. Thanks
Tom Received on Fri Mar 21 1997 - 00:00:00 CET

This message: [ Message body ]
Next message: CITI63: "****NY/NJ-DATA MODELERS/LOGICAL/PHYSICAL WANTED****"
Previous message: CHEELYM9_at_spanky.badm.sc.edu: "Re: ros -200"
Next in thread: Loren Davidson: "Re: Master - Detail Report From SQLPLUS"
Reply: Loren Davidson: "Re: Master - Detail Report From SQLPLUS"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message