Home » SQL & PL/SQL » SQL & PL/SQL » Total of a column at each page end and Grand total at the end of report. (Oracle 7.3, Unix)
Total of a column at each page end and Grand total at the end of report. [message #381229] Thu, 15 January 2009 22:09 Go to next message
sunidhi
Messages: 36
Registered: January 2006
Location: New Delhi
Member
Dear All,

How can we get the total of a column at each end of Page and Grand Total of same column at end of report simultaneously in SQL.

For Example :-

Page 1

Name Amount

A 10
B 20
C 30

Total 60

Page 1 end

Page 2

Name Amount

D 40
E 30
F 20

Total 90

Page 2 End

Page 3

Name Amount

G 50
H 60

Total 110

Grad.Total 260


Thanks & Regards,

Sunidhi
Re: Total of a column at each page end and Grand total at the end of report. [message #381238 is a reply to message #381229] Thu, 15 January 2009 23:53 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
have a look at this may be it will be helpful to you

http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_functions_2102.htm
Re: Total of a column at each page end and Grand total at the end of report. [message #381246 is a reply to message #381229] Fri, 16 January 2009 00:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your client tool?

Always post a Test case: create table and insert statements along with the result you want with these data.

Are you really using version 7.3?

Regards
Michel

Re: Total of a column at each page end and Grand total at the end of report. [message #381359 is a reply to message #381238] Fri, 16 January 2009 08:13 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
rajasekhar857 wrote on Fri, 16 January 2009 00:53
have a look at this may be it will be helpful to you

http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_functions_2102.htm


V11 functions will not work in 7.3
Re: Total of a column at each page end and Grand total at the end of report. [message #381461 is a reply to message #381359] Sat, 17 January 2009 01:30 Go to previous messageGo to next message
sunidhi
Messages: 36
Registered: January 2006
Location: New Delhi
Member
Dear All,

This is function is not possible in Oracle 7.3.

Is there any way out in Oracle 7.3.

Regards,

Nitin
Re: Total of a column at each page end and Grand total at the end of report. [message #381463 is a reply to message #381229] Sat, 17 January 2009 01:37 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Is there any way out in Oracle 7.3.
NO
But why are you limited to solutions 15+ years old?
Please join the 21st century!
At least get current to supported versions;
or at lest within minus one version & not FOUR!
Re: Total of a column at each page end and Grand total at the end of report. [message #381464 is a reply to message #381461] Sat, 17 January 2009 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 16 January 2009 07:31
What is your client tool?

Always post a Test case: create table and insert statements along with the result you want with these data.

Are you really using version 7.3?

Regards
Michel


Answer my question and post what is requested.


Re: Total of a column at each page end and Grand total at the end of report. [message #381908 is a reply to message #381463] Tue, 20 January 2009 04:31 Go to previous messageGo to next message
sunidhi
Messages: 36
Registered: January 2006
Location: New Delhi
Member
Dear Blackswan,

Our company still presists on Oracle 7.3, lets see how long they will take to upgrade themselves, till time we had to do our task in same version only.

Please tell me whether is it possible take Total of a column at each page end and Grand total at the end of report.

Thanks & Regards,

Sundhi
Re: Total of a column at each page end and Grand total at the end of report. [message #381913 is a reply to message #381908] Tue, 20 January 2009 04:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Sat, 17 January 2009 08:46
Michel Cadot wrote on Fri, 16 January 2009 07:31
What is your client tool?

Always post a Test case: create table and insert statements along with the result you want with these data.

Are you really using version 7.3?

Regards
Michel


Answer my question and post what is requested.

Re: Total of a column at each page end and Grand total at the end of report. [message #382326 is a reply to message #381464] Wed, 21 January 2009 23:39 Go to previous messageGo to next message
sunidhi
Messages: 36
Registered: January 2006
Location: New Delhi
Member
Dear Michel,

We are still using Oracle 7.3 on Unix 10.0.

Help me regarding above said problem if possible in this Current Version.

Regards,

Sunidhi
Re: Total of a column at each page end and Grand total at the end of report. [message #382329 is a reply to message #381229] Wed, 21 January 2009 23:42 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>We are still using Oracle 7.3 on Unix 10.0.
A 100% totally unsupported combination!
V7.3 was obsoleted & retired years before Unix 10.0 was released!
Re: Total of a column at each page end and Grand total at the end of report. [message #382363 is a reply to message #382326] Thu, 22 January 2009 00:51 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your CLIENT PROGRAM? What is your CLIENT PROGRAM? What is your CLIENT PROGRAM? What is your CLIENT PROGRAM? What is your CLIENT PROGRAM?
No possible help until you answer this question.

Regards
Michel

Previous Topic: Simple union in oracle 10g?
Next Topic: passing string value into a cusrsor
Goto Forum:
  


Current Time: Fri Dec 09 04:13:42 CST 2016

Total time taken to generate the page: 0.10628 seconds