Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Formatting query results
clbeck_at_us.oracle.com (Christopher Beck) schrijfbewerkingen: > On 13 Jan 1999 16:40:20 GMT, Martin <I.want_at_no.mail> wrote:
>
> 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.
>
>
> Christopher Beck
> Oracle Corporation
> clbeck_at_us.oracle.com
> Reston, VA.
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
Thanks Christopher, this works fine, I didn't realize I could do it in one statement.
(sorry that the newsreader I use on my work doesn't support threading) Received on Thu Jan 14 1999 - 02:35:40 CST