Re: sql query formatting

Hello,
that's possible and easy, just use BREAK ON DNAME.

Suppose your query has ORDER BY clause beginning with DNAME ...

See Oracle Docs: SQL*Plus/Understanding SQL*Plus/Formatting Query Results/Clarifying Your Reports With Spacing And Summary Lines.

or

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a82950/ch4.htm#1001506

HTH,
Ales

Madis Priilinn <madp_at_math.ut.ee> wrote in message news:Pine.GSO.4.33.0108141634540.29500-100000_at_madli.ut.ee...
>
> Hello!
>
> I would like to format one query. Right now it shows something like this
> example (grouped by first column):
>
>
> DNAME JOB Total Empl Average Sa
> --------------- --------- ---------- ----------
> ACCOUNTING CLERK 1 15600
> ACCOUNTING MANAGER 1 29400
> ACCOUNTING PRESIDENT 1 60000
> ACCOUNTING All Jobs 3 35000
> RESEARCH ANALYST 2 36000
> RESEARCH CLERK 2 11400
> RESEARCH MANAGER 1 35700
> RESEARCH All Jobs 5 26100
>
> But my intention is to get something like this:
>
> DNAME JOB Total Empl Average Sa
> --------------- --------- ---------- ----------
> ACCOUNTING CLERK 1 15600
> MANAGER 1 29400
> PRESIDENT 1 60000
> All Jobs 3 35000
> RESEARCH ANALYST 2 36000
> CLERK 2 11400
> MANAGER 1 35700
> All Jobs 5 26100
>
>
> I've searched several hours already but can't find anything...But I don't
> want to believe this is impossible to do :)
>
> Thank You,
>
> Madis
>
Received on Tue Aug 14 2001 - 10:14:35 CDT