Re: Challenging SQL*Plus Reporting Question

From: Brian Membrey <horsemth_at_mel.switch.net.au>
Date: 1997/02/16
Message-ID: <01bc1c5e$6031a0e0$41a966cb_at_default>#1/1

The formatting can be achieved quite easily by including a BREAK statement in the SQL to remove duplicate titles and give the space line ...

BREAK ON PUB_TITLE NODUP SKIP 1 I'm not sure what you're trying to achieve because the data model does not link COMPANY to AUTHOR and any attempt to select will cause extra rows thus

PUB_TITLE                          PUB_COMPANY_NAME       PUB_AUTHOR_NAME
--------------------                        --------------------           
           --------------------
AARDVARK ANNUAL           AARDVARK ASSOCIATES   ALBERT ANTEATER JNR.
                                           AARDVARK ASSOCIATES   PATTI
PORCUPINE
                                           FREE NATURE PRESS        ALBERT
ANTEATER JNR.
                                           FREE NATURE PRESS        PATTI

PORCUPINE

KANGAROO QUARTERLY   OUTBACK PRESS               DEMI DINGO
                                          OUTBACK PRESS               WALLY
WOMBAT
                                          WALLABY PUBLICATIONS  DEMI DINGO
                                         WALLABY PUBLICATIONS   WALLY

WOMBAT Surely there should be a relationship between the two ... after all ORACLE is a RELATIONAL Date Base

busch1_at_llnl.gov wrote in article <5du3dn$203_at_lll-winken.llnl.gov>...
> I have three tables:
>
> Publication: Company: Author:
> pub_id_no varchar2(7) pub_id_no varchar2(7) pub_id_no
 varchar2(7)
> pub_title varchar2(20) pub_company_name varchar2(20) pub_author_name
 varchar2(20)
> pub_date date
>
> Each publication can have 0 through N companies
> Each publication can have 0 through N authors
>
> I'd like a report like this:
>
> Publication Title Company Author
>
> Title #1 1st company of pub 1 1st author of pub
 1
> 2nd company of pub 1 2nd author of pub
 1
> Nth company of pub 1 nth author of pub
 1
>
> Title #2 etc.
>
> Is there any way to do this is SQL*Plus?
>
> ---
> Jeff Busch Internet busch1_at_llnl.gov
> Voice (510) 423-9134 Fax (408) 263-1360
>
>
>
>
Received on Sun Feb 16 1997 - 00:00:00 CET