RE: CUBES

From: <SRAJENDRAN_at_nlfs.com>
Date: Thu, 01 Feb 2001 11:47:59 -0800
Message-ID: <F001.002A7E2B.20010201114629@fatcity.com>

thanks

-----Original Message-----
Sent: Thursday, February 01, 2001 1:37 PM To: Multiple recipients of list ORACLE-L

                Just try :

                SELECT   deptno, job, SUM(sal)
                FROM     emp
                group by cube(deptno, job)
                /

and see the difference between rollup and cube! Cube basically adds one more dimension, it gives summary for each value in "job" field. For e.g. what was total salary of all clerks in all departments.

Hitarth Trivedi

Oracle Certified DBA (7.3)
Sun Certified Java 2 Programmer
MCSE, MCP+I
315-362-1162
trivedh_at_telergy.net

                -----Original Message-----
                From:   SRAJENDRAN_at_nlfs.com [mailto:SRAJENDRAN_at_nlfs.com]
                Sent:   Thursday, February 01, 2001 1:01 PM
                To:     Multiple recipients of list ORACLE-L
                Subject:        CUBES





                Hi,
                Could someone please give me an example for cube.   I could
understand
                rollup using the following example.
                SELECT   deptno, job, SUM(sal)
                FROM     emp
                group by rollup(deptno, job)
                /

                Thank you,
                Srini

                -- 
                Please see the official ORACLE-L FAQ: http://www.orafaq.com
                -- 
                Author: 
                  INET: SRAJENDRAN_at_nlfs.com

                Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
                San Diego, California        -- Public Internet access /
Mailing Lists
        
--------------------------------------------------------------------
                To REMOVE yourself from this mailing list, send an E-Mail
message
                to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
                the message BODY, include a line containing: UNSUB ORACLE-L
                (or the name of mailing list you want to be removed from).
You may
                also send the HELP command for other information (like

subscribing).

                -- 
                Please see the official ORACLE-L FAQ: http://www.orafaq.com
                -- 
                Author: 
                  INET: SRAJENDRAN_at_nlfs.com

                Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
                San Diego, California        -- Public Internet access /
Mailing Lists
        
--------------------------------------------------------------------
                To REMOVE yourself from this mailing list, send an E-Mail
message
                to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
                the message BODY, include a line containing: UNSUB ORACLE-L
                (or the name of mailing list you want to be removed from).
You may
                also send the HELP command for other information (like

subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Trivedi, Hitarth
INET: HTrivedi_at_telergy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: SRAJENDRAN_at_nlfs.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------