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

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

Post by NetComra » Sat, 01 Dec 2001 05:16:45



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

 
 
 

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

Post by -wisegu » Sat, 01 Dec 2001 05:19:18




Quote:> 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

This is off-topic.  Please refer this question to an Oracle discussion group
only.

--
-wiseguy
slummin it in Colorado ski country, while watching the IT industry move
to India, and thinking about retraining as a Sanitation Engineer

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

 
 
 

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

Post by NetComra » Sat, 01 Dec 2001 07:15:28


i cancelled the message almost right away (as I realized i posted to
the wrong newsgroup), I don't know why u got it.

my apologies




>> 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

>This is off-topic.  Please refer this question to an Oracle discussion group
>only.

>--
>-wiseguy
>slummin it in Colorado ski country, while watching the IT industry move
>to India, and thinking about retraining as a Sanitation Engineer

>-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
>http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
>-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

.......
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
 
 
 

1. (<><>)*Linux*Screen*Difficulties*(<><>)

There is none. Its a matter of preference.

Edit /etc/X11/XF86Config file by putting a # in front of the line that starts
with the word "virtual".

--
All the best,
Shawn Smith  !UNT Proud!
My Resume http://sites.netscape.net/shawnspad/shawn_smith_resume.htm
My freeware: http://sites.netscape.net/shawnspad

2. PAS16:scsi timed out

3. <><><> MOUNTING EXTENDED PARTITION <><><>

4. IDE CD-ROM supported??

5. Wanted: <><><> Unix Specialist <><><>

6. Linux Kernel 1.4

7. LILO help <><><><><><>

8. Database Magic # Mismatch with NN and Slackware 3.0

9. <Alt>+<key> = <Esc><key> ?

10. *{<><>}*Linux*Screen*Difficulties*{<><>}*

11. << <<anyone using dyn-html?>> >>

12. Samba problem: WinXP <-> ADSL <-> Internet <-> Cable <-> Linux

13. SunSparc <--> modem <--> 486DLC <--> RS232/SLIP <--> 386sx