| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: sql plus question - duh - here is the query :)
Joe D <joed_at_icoms.com> wrote in message news:38345fbe_at_News.Destek.net...
> I have a query that will product a report broken down this way:
>
> 'store name' 'store number' 'store total' 'transaction type'
'#
> transactions'
> xyz 500000 $5,555.00 1
> 3
> $200.00 3
> 1
>
>
> my dilemma is this: there are 6 possible transaction type. I can break the
> report on transaction type so that any given store with more then 1 type
of
> transaction has them listed on a new line. (as shown above). I want to
> either, 1) at the end of the report to show report total count for type 1,
> 2, 3, 4, 5, & 6. or 2) modify
> the output so that each transaction type has it's own column. (that way
> excel can do a sum on the column)
>
> my choice is the 1 option. report just looks cleaner. But, I don't know
how
> to do that. HELP please....
>
> Thanks in Advance.
>
>
begin 666 report_tmp.sql
M8VQE87(@8V]L=6UN<PT*8VQE87(@8G)E86MS#0IC;&5A<B!C;VUP=71E<PT*
M<V5T(&5C:&\@;V9F#0IS970_at_9F5E9&)A8VL@;V9F#0IS970@=F5R:69Y(&]F
M9_at_T*<V5T(&YE=W!A9V4@,0T*<V5T('-P86-E(#$-"G-E="!L:6YE<VEZ92 Q
M,S(-"G-E="!P86=E<VEZ92 S-PT*8G)E86L@;VX@;F%M92!S:VEP(#$@;VX@
M<F5P;W)T#0I214T_at_8V]M<'5T92!S=6T@;V8@=&]T86P@;VX@<F5P;W)T#0IC
M;VUP=71E(&-O=6YT(&]F(&YA;64@;VX@<F5P;W)T#0IC;VUP=71E(&-O=6YT
M(&]F(").=6TN(%1R86YS+B(@;VX@;F%M90T*8V]M<'5T92!C;W5N="!O9B B
M3G5M+B!4<F%N<RXB(&]N(')E<&]R= T*86-C97!T(&UO;G1H('!R;VUP=" G
M16YT97(@=&AE(&UO;G1H(&]F('1H92!R97!O<G0Z)PT*<W!O;VP_at_8SI<=&UP
M7$UO;G1H;'E?4W1O<F5S7W)E<&]R="YT>'0-"G1T:71L92!L969T("=->2!3
M=&]R92 G)FUO;G1H)R!-;VYT:&QY(%-T;W)E<R!297!O<G0G(" M#0IR:6=H
M=" G4&%G93HG(&9O<FUA=" Y.3D@<W%L+G!N;R!S:VEP(#(-"F-O;'5M;B!N
M86UE(&AE861I;F<@(E-T;W)E($YA;64B(&9O<FUA="!!-C4-"F-O;'5M;B!K
M97E?<W1O<F5?<V5Q:60@:&5A9&EN9R G4W1O<F4_at_240G(&9O<FUA=" Y.3DY
M.3D-"F-O;'5M;B!T;W1A;"!H96%D:6YG("=3=&]R92!4;W1A;"<@9F]R;6%T
M("0Y+#DY.2PY.3DN.3D-"F-O;'5M;B B='EP92!T<F%N<R(@:&5A9&EN9R G
M5'EP92!4<F%N<R<@9F]R;6%T(#DY.0T*8V]L=6UN(").=6TN(%1R86YS+B(@
M:&5A9&EN9R G3G5M+B!4<F%N<R<@9F]R;6%T(#DY.3DY.0T*<V5L96-T('-V
M+FYA;64L('-V+DM%65]35$]215]315%)1"P@<W5M*')V+F%M;W5N=" K(')V
M+F9R96EG:'0I(%1O=&%L+ T*<G8N=')A;G-A8W1I;VY?='EP92 B='EP92!T
M<F%N<R(L(&-O=6YT*')V+G1R86YS86-T:6]N7W1Y<&4I(").=6TN(%1R86YS
M+B(-"F9R;VT@<F5P;W)T7W-T;W)E<U]V:65W('-V+" -"E)%4$]25%]44D%.
M4T%#5$E/3E]62457(')V#0IW:&5R92!R=BYT<F%N<V%C=&EO;E]T>7!E(#X]
M("<Q)R -"F%N9"!44D%.4T%#5$E/3E]$051%(#X]("9S=&%R=%]D871E(&%N
M9"!44D%.4T%#5$E/3E]$051%(#P]("9E;F1?9&%T92 -"F%N9"!S=BY35$]2
M15])1" ](')V+G-T;W)E7VED#0IG<F]U<"!B>2!S=BYN86UE+"!S=BY+15E?
M4U1/4D5?4T51240L(')V+G1R86YS86-T:6]N7W1Y<&4-"CL-"G-P;V]L(&]F
#9_at_T*
 |
 |