Re: Formatting query results

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Wed, 13 Jan 1999 19:41:44 GMT
Message-ID: <369ff5b0.23985238@inet16.us.oracle.com>

On 13 Jan 1999 16:40:20 GMT, Martin <I.want_at_no.mail> wrote:

>Hi all,
>
>I'm trying to format the following query:
>
>SET HEADING ON
>SET PAGESIZE 10000
>CLEAR BREAKS
>COLUMN MAAND FORMAT A9
>COLUMN JAAR FORMAT A4
>COLUMN MAANDNR NOPRINT
>COLUMN NET FORMAT A4
>BREAK ON JAAR SKIP 2 NODUP
>BREAK ON NET SKIP 1 NODUP <---- This is no use :-(

I think you want...

break on jaar skip 2 on net skip 1 nodup

eg.

SQL> clear breaks
breaks cleared
SQL> select * from foo;

         A B C
---------- ---------- ----------

         1          1          1
         1          2          2
         1          1          2
         1          2          1

SQL> break on a skip 2 on b skip 1 nodup SQL> select a, b, c
  2 from foo
  3 group by a, b, c;

         A B C
---------- ---------- ----------

         1          1          1
                               2

                    2          1
                               2

hope this helps

chris.

>
>I understand only one break can be defined at one time,
>but is there a way to get the layout I want ? (with or without breaks).
>
>TIA,
>
>Martin

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jan 13 1999 - 13:41:44 CST