Re: SQL to compute sums (similar to SQL*plus break on <column> compute sum of <other_col> on <column>)

I think you're thinking of the group by cube and group by rollup analytical functions. Introduced in 8i, they've been enhanced in 9i so that you can select which of the groups you want to see, rather than have all of them displayed. You can also concatenate columns in 9i for the purposes of grouping by, which you couldn't do in 8i.

My site, books, 8i New Features has got a bit about them (round about page 14 if memory serves).

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message
news:3c0697c6.2586383192_at_news.globix.com...


> I know there is some 'new' SQL that can do this, but can't think of a

> way to look for it. Although not sure which version it was introduced

> in 8i or 9i.

>

> Can you point me into the right direction?

>

> Thnx.

> .......

> We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

> Andrey Dmitriev eFax: (978) 383-5892  Daytime: (917) 750-3630

> AOL: NetComrade ICQ: 11340726 remove NSPAM to email