Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with a SQL statement

Re: Help with a SQL statement

From: John Lillywhite <jlillywhite_at_iap.org.uk>
Date: Mon, 21 Sep 1998 15:24:55 +0100
Message-ID: <6u5ni7$4ba$1@taliesin.netcom.net.uk> 





I wrote the attached to list tables with their tablespaces and rowcounts...
rgds, john




stuco_at_mailcity.com wrote in message <6tmeog$l5b$1_at_nnrp1.dejanews.com>...


>I would like to issue one SQL or PL/SQL statement that would gather


>table_names and their respective row counts. How can this be done?? I know


>that I can write a SQL statement to create a bunch of SQL calls, but I


would


>rather only make one call to the database to save on overhead.


>


>thanks ever so much!


>


>Stuart Cowen


>Paladin Consulting - Dallas


>


>-----== Posted via Deja News, The Leader in Internet Discussion ==-----


>http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum






begin 666 qmytables.sql


M4D5-(%)E<&]R="!O;B!T86)L97,L(&EN8VQU9&EN9R!R;W<@8V]U;G0L(&9O
M<B!C=7)R96YT(&QO9V=E9"UO;B!U<V5R+@T*4D5-(&-R96%T960@.3_at_P.3 T
M($I23 T*4U!/3TP@("!Q;7ET86)L97,N;&]G#0I3150_at_4T525D523U544%54
M($]."5-)6D4@,3 P,# P($9/4DU!5"!73U)$7U=205!0140-"D1%0TQ!4D4-

M"@EO=VYE<FYA;64)=F%R8VAA<C(H,S I.PT*(" @;FX@(" @(" @(" @4$Q3
M7TE.5$5'15(@.CT@,#L-"B @(')E=" @(" @(" @(&EN=&5G97([#0H@("!C
M;G0@(" @(" @("!I;G1E9V5R(" @(" Z/2 Y.3D@.PT*(" @8VYT,2 @(" @
M(" @:6YT96=E<B @(" @.CT@,3$Q,3$Q,3$@.PT*(" @8VYT,B @(" @(" @
M:6YT96=E<B @(" @.CT@,C(R,C(R,C(@.PT*(" @<W1M=" @(" @(" @:6YT
M96=E<B @(" @.CT@,#L-"B @(&5R<F1A=&$@(" @(" @('9A<F-H87(R*#@P
M*2 @.CT@)VYO="!Y970@<V5T)SL-"B @(%194$4@(')E8W1Y<"!)4R!214-/
M4D0-"B @(" @("@@("!O=VYE<B @(" @("!V87)C:&%R,B_at_Q,# I#0H@(" @


M(" @("P@=&)S<&YA;64@(" @=F%R8VAA<C(H,3 P*0T*(" @(" @(" L('1A
M8FYA;64@(" @('9A<F-H87(R*#$P,"D-"B @(" @(" @+"!T86)C;G0@(" @
M("!I;G1E9V5R#0H@(" @(" I.PT*(" @5%E012 @=&%B='EP92!)4R!404),
M12!/1B!R96-T>7 -"B @(" @($E.1$58($)9($))3D%265])3E1%1T52.PT*
M(" @=&%B(" @=&%B='EP93L-"B @(&IR;'1E<W0@($580T505$E/3CL-"@T*

M+RHM+2!P<F]C('1O(&]U='!U="!P;"]S<6P@=&%B;&4_at_8V]N=&5N=',@("HO
M#0H@("!04D]#14154D4@;W5T<'5T=&%B;&4@*'1A8FEN($E.('1A8G1Y<&4I
M($E3#0H@(" @("!R96,@("!R96-T>7 [#0H@("!"14=)3_at_T*(" @(" @248@
M=&%B:6XN1DE24U0_at_25,@3E5,3"!42$5.#0H@(" @"0E$0DU37T]55%!55"Y0
M551?3$E.12_at_G3F\@=&%B;&5S('1O(&-O=6YT+BXN("<I.PT*(" @(" @14Q3


M10T*(" @(" @(" @/#QO=71E<C(^/@T*(" @(" @(" @1D]2(&YN($E.('1A

M8FEN+D9)4E-4+BYT86)I;BY,05-4#0H@(" @(" @("!,3T]0#0H@(" @(" @
M(" @("!R96,@.CT@=&%B:6XH;FXI.PT*+RHM+2!B;&]C:R!T;R!O=71P=70@
M<VEN9VQE(')O=R!O9B!P;"]S<6P@=&%B;&4@(" J+PT*(" @(" @(" @(" @
M0D5'24X-"BTM(%)!25-%(&IR;'1E<W0[(" M+2!T;R!T97-T(&5X8V5P=&EO
M;B!H86YD;&EN9PT*#0H@(" @(" @(" @(" @("!$0DU37T]55%!55"Y0551?
M3$E.10T*(" @(" @(" @(" @(" @(" @*" @(" @)T-O=6YT+W1A8FQE(#H@
M)PT*(" @(" @(" @(" @(" @(" @(" @?'PG(" G?'P@=&]?8VAA<BAR96,N
M=&%B8VYT+"<Y.3DY.3DY.3DY)RD-"B @(" @(" @(" @(" @(" @(" @('Q\
M)R @)WQ\(')E8RYT86)N86UE#0H@(" @(" @(" @(" @(" @(" I.PT*(" @
M(" @(" @(" @15A#15!424].#0H@(" @(" @(" @(" @("!72$5.($]42$52
M4R!42$5.#0H@(" @(" @(" @( D@(" )1$)-4U]/5510550N4%547TQ)3D4H


M)T5X8V5P=&EO;B!R86ES960Z("=\?" -"B @(" @(" @(" @(" @(" @(" @

M(" @(" @(" @(" @(" @(" @(" @(" @(" @(%-13$524DTH4U%,0T]$12DI
M.PT*(" )(" @(" @(" @(" @"41"35-?3U544%54+E!55%],24Y%*"=%<G)D
M871A/2 G?'P_at_97)R9&%T82D[#0H@(" @(" @(" @(" @(" @("!$0DU37T]5
M5%!55"Y0551?3$E.10T*(" @(" @(" @(" @(" @(" @*" @(" @)T-O=6YT
M+W1A8FQE(#H@)PT*(" @(" @(" @(" @(" @(" @(" @?'PG(" G?'P@)RHJ
M*BHJ(&-A;FYO="!O=71P=70@=&AI<R!L:6YE)PT*(" @(" @(" @(" @(" @
M(" @*3L-"B @(" @(" @(" @($5.1#L@("TM(&)L;V-K(&]U='!U=')O=PT*
M(" @(" @(" @14Y$($Q/3U @;W5T97(R.PT*(" @(" @14Y$($E&.PT*(" @


M(" @4D5455)..PT*(" @14Y$.R @+2T@<')O8R!O=71P=71T86)L90T*#0HO
M*BTM(&9U;F-T:6]N('1O(&=E="!R96-O<F0_at_8V]U;G0_at_9F]R(&$@=&%B;&4@
M(" J+PT*(" @1E5.0U1)3TX_at_9V5T<F5C8VYT*'1A8FYA;64_at_24X@0TA!4BD@

M4D5455).($E.5$5'15(@25,-"B @(&-I9" @(" @(" @(" @(&EN=&5G97([
M#0H@("!C;G0@(" @(" @(" @("!I;G1E9V5R(" @(" Z/2 M,3L-"B @(&5R
M<F1A=&$@(" @(" @('9A<F-H87(R*#@P*2 @.CT@)VYO="!Y970@<V5T)SL-


M"B @($)%1TE.#0H@(" @("!E<G)D871A(#H]("=$>6YA;6EC(%-13"!E<G)O
M<B M(&]P96X_at_8W5R<V]R(&EN(&9U;F-T:6]N(&=E=')E8V-N="<[#0H@(" @
M("!C:60@.CT_at_1$)-4U]344PN3U!%3E]#55)33U([#0H@(" @("!E<G)D871A

M(#H]("=#86YN;W0_at_9FEN9"!R96-O<F0_at_8V]U;G0_at_9F]R('1A8FQE("T_at_8V]U
M;G0@<V5T('1O("TQ)SL-"B @(" @($1"35-?4U%,+E!!4E-%*&-I9"PH)U-%
M3$5#5"!#3U5.5"@J*2!&4D]-("=\? T*(" @(" @(" @(" @(" @(" @("!T
M86)N86UE*2P_at_1$)-4U]344PN5C<I.PT*(" @(" @97)R9&%T82 Z/2 G1'EN
M86UI8R!344P_at_97)R;W(@:6X_at_9G5N8W1I;VX_at_9V5T<F5C8VYT(#H_at_8VED/2=\
M? T*(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @


M(" @(" @(" @(" @=&]?8VAA<BAC:60I.PT*(" @(" @1$)-4U]344PN1$5&

M24Y%7T-/3%5-3BAC:60L,2QC;G0I.PT*(" @(" @<F5T(#H]($1"35-?4U%,
M+D5814-55$4H8VED*3L-"B @(" @(')E=" Z/2!$0DU37U-13"Y&151#2%]2
M3U=3*&-I9"D[#0H@(" @("!$0DU37U-13"Y#3TQ534Y?5D%,544H8VED+#$L


M8VYT*3L-"B @(" @($1"35-?4U%,+D-,3U-%7T-54E-/4BAC:60I.PT*(" @

M(" @4D5455).*&-N="D[#0H@("!%6$-%4%1)3TX-"B @(" @(%=(14X_at_3U1(
M15)3(%1(14X-"B @"2 @( E$0DU37T]55%!55"Y0551?3$E.12_at_G17AC97!T
M:6]N(')A:7-E9#H@)WQ\(%-13$524DTH4U%,0T]$12DI.PT*(" )(" @"41"

M35-?3U544%54+E!55%],24Y%*"=%<G)D871A/2 G?'P_at_97)R9&%T82D[#0H@

M(" @(" @("!)1B!$0DU37U-13"Y)4U]/4$5.*&-I9"D_at_5$A%3_at_T*(" @(" @
M(" @(" @1$)-4U]344PN0TQ/4T5?0U524T]2*&-I9"D[#0H@(" @(" @("!%
M3%-%#0H@(" @(" )"41"35-?3U544%54+E!55%],24Y%*"=#=7)S97(@;F]T
M(&]P96X@)RD[#0H@(" @(" @("!%3D0_at_248[#0H@(" @(" @("!215154DXH


M+3$I.PT*(" @14Y$.R @+2T_at_9FX@9V5T<F5C8VYT#0H-"D)%1TE.(" @("TM
M+2TM+2TM+2TM(&UA:6X_at_8FQO8VL@+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0H@

M("!314Q%0U0@=7-E<B!)3E1/(&]W;F5R;F%M92!&4D]-($1504P[#0H-"BTM
M(&=E="!T86)L97-P86-E<PT*"3P\;W5T97(^/@T*"49/4B!T8G-P<F5C($E.

M#0H)(" @*%-%3$5#5" @9&ES=&EN8W0@;W=N97(L('1A8FQE<W!A8V5?;F%M
M90T*"2 @(" @($923TT@(&%L;%]T86)L97,-"@D)("!72$5212!O=VYE<B ]
M(&]W;F5R;F%M90T*"0D@($]21$52($)9(&]W;F5R+"!T86)L97-P86-E7VYA


M;64-"@D@(" I#0H)3$]/4 T*"2 @(%-%3$5#5" @0T]53E0H=&%B;&5?;F%M
M92D_at_24Y43R!C;G0R#0H)(" @(" @1E)/32 @86QL7W1A8FQE<PT*"0D)"5=(

M15)%(&]W;F5R(#T@=&)S<')E8RYO=VYE<@T*"0D)"2 @04Y$('1A8FQE<W!A
M8V5?;F%M92 ]('1B<W!R96,N=&%B;&5S<&%C95]N86UE.PT*(" )"41"35-?
M3U544%54+E!55%],24Y%*"=486)L97,@4F5P;W)T("<-"B @(" @(" @(" @


M?'QT;U]C:&%R*'-Y<V1A=&4L)R(@;VX@(D1!62!$1"U-3TXM25E962(@870@
M(FAH.FUI.G-S)RDI.PT*(" )"41"35-?3U544%54+E!55%],24Y%* T*(" @


M(" @(" @(" @(" @("=/=VYE<B Z("<@(" @(" @(" @('Q\('1B<W!R96,N
M;W=N97(@#0H@(" @(" @(" @("!\?" @)R @(" @5&%B;&5S<&%C92 Z("<@
M?'P@=&)S<')E8RYT86)L97-P86-E7VYA;64-"B @(" @(" @(" @('Q\(" G
M(" @("!486)L96-O=6YT(#H@)R!\?"!C;G0R( T*(" @(" @(" @(" @(" @


M(" @(" @(" @(" @*3L-"@T*+2T_at_9V5T('1A8FQE;F%M92!A;F0@<F]W8V]U

M;G0-"@D)/#QI;FYE<C$^/@T*"0E&3U(@=&)R96,@24X-"@D)(" @*%-%3$5#
M5" @=&%B;&5?;F%M90T*"0D)"4923TT@(&%L;%]T86)L97,@( T*"0D)"5=(
M15)%(&]W;F5R(#T@=&)S<')E8RYO=VYE<@T*"0D)"2 @04Y$('1A8FQE<W!A


M8V5?;F%M92 ]('1B<W!R96,N=&%B;&5S<&%C95]N86UE#0H)"0D)3U)$15(@

M0ED@=&%B;&5?;F%M90T*"0D)*0T*"0E,3T]0#0H@(" @(" @("!S=&UT(#H]
M(#$[#0HO*B!C;VUP;W-E('1H92!R96-O<F0@*B\-"B @(" @(" @('-T;70@
M.CT@.#L-"B @(" @(" @(&YN(#H](&YN("L@,3L-"B @(" @(" @('1A8BAN
M;BDN;W=N97(@(" @.CT@('1B<W!R96,N;W=N97([#0H@(" @(" @("!S=&UT


M(#H](#D[#0H@(" @(" @("!T86(H;FXI+G1B<W!N86UE(#H]("!T8G-P<F5C

M+G1A8FQE<W!A8V5?;F%M93L-"B @(" @(" @('-T;70@.CT@,3 [#0H@(" @
M(" @("!T86(H;FXI+G1A8FYA;64@(#H]("!T8G)E8RYT86)L95]N86UE.PT*
M(" @(" @(" @<W1M=" Z/2 Q,3L-"B @(" @(" @('1A8BAN;BDN=&%B8VYT
M(" @.CT@(&=E=')E8V-N="AT8G)E8RYT86)L95]N86UE*3L-"B @(" @(" @


M('-T;70@.CT@,C [#0H)"45.1"!,3T]0(&EN;F5R,3L-"B @"45.1"!,3T]0
M(&]U=&5R.PT*(" @;W5T<'5T=&%B;&4H=&%B*3L@("TM(&]U='!U="!P;"]S
M<6P@=&%B;&4_at_8V]N=&5N=',-"@T*15A#15!424].#0H@("!72$5.($]42$52
M4R!42$5.#0H@( D)1$)-4U]/5510550N4%547TQ)3D4H)T5X8V5P=&EO;B!R
M86ES960Z("=\?"!344Q%4E)-*%-13$-/1$4I*3L-"B @( E$0DU37T]55%!5
M5"Y0551?3$E.12_at_G17)R9&%T83T@)WQ\(&5R<F1A=&$I.PT*(" )"41"35-?
M3U544%54+E!55%],24Y%*"=S=&UT/2=\?'-T;71\?"<@("!N;CTG?'P@;FXI
M.PT*"0E$0DU37T]55%!55"Y0551?3$E.12_at_G4%))3U(H;FXI/2=\?'1A8BY0

M4DE/4BAN;BDI.PT*"0E$0DU37T]55%!55"Y0551?3$E.12_at_G($Y%6%0H;FXI

M/2=\?'1A8BY.15A4*&YN*2D[#0H)"41"35-?3U544%54+E!55%],24Y%*"=&
M25)35"AN;BD])WQ\=&%B+D9)4E-4*3L-"@D)1$)-4U]/5510550N4%547TQ)
M3D4H)R!,05-4*&YN*3TG?'QT86(N3$%35"D[#0H@(" @("!)1B!T86(N4%))

M3U(H;FXI($E3($Y/5"!.54Q,(%1(14X-"B @( D)1$)-4U]/5510550N4%54
M7TQ)3D4-"B @(" @(" @(" @("@G4')E=FEO=7,@5&%B(&5N=')Y("@G?'P@
M=&%B+E!224]2*&YN*7Q\)RDZ(#PG?'P-"B @(" @(" @(" @(" @(" @(" @


M(" @('1A8BAT86(N4%))3U(H;FXI*2YO=VYE<@T*(" @(" @(" @(" @(" @
M?'PG/B \)WQ\('1A8BAT86(N4%))3U(H;FXI*2YT8G-P;F%M90T*(" @(" @

M(" @(" @(" @?'PG/B \)WQ\('1A8BAT86(N4%))3U(H;FXI*2YT86)N86UE


M#0H@(" @(" @(" @(" @("!\?"<^(#PG?'P@=&%B*'1A8BY04DE/4BAN;BDI
M+G1A8F-N= T*(" @(" @(" @(" @(" @?'PG/B<I.PT*(" @(" @14Y$($E&
M.PT*(" @(" @248@;FX@/#T@=&%B+DQ!4U0_at_5$A%3_at_T*(" @"0E$0DU37T]5
M5%!55"Y0550-"B @(" @(" @(" @("@G0W5R<F5N=" @5&%B(&5N=')Y("@G
M?'QN;GQ\)RDZ(#PG#0H@(" @(" @(" @(" @(" @(" @(" @?'P@=&%B*&YN
M*2YO=VYE<@T*(" @(" @(" @(" @(" @?'PG/B \)WQ\('1A8BAN;BDN=&)S
M<&YA;64-"B @(" @(" @(" @(" @('Q\)SX@/"=\?"!T86(H;FXI+G1A8FYA


M;64-"B @(" @(" @(" @("D[#0H@(" @(" @("!)1B!T86(H;FXI+G1A8F-N

M="!)4R!.3U0_at_3E5,3"!42$5.#0H@(" @(" )"41"35-?3U544%54+E!55%],
M24Y%*"<^(#PG?'P@=&%B*&YN*2YT86)C;G0I.PT*(" @(" @(" @14Y$($E&
M.PT*(" @( D)1$)-4U]/5510550N4%547TQ)3D4H)SXG*3L-"@T*(" @(" @

M14Y$($E&.PT*+RH-"B @(" @(&]U='!U='1A8FQE*'1A8BD[(" M+2!O=71P

M=70@<&PO<W%L('1A8FQE(&-O;G1E;G1S#0HJ+PT*(" @(" @4D%)4T4[#0I%
M3D0[#0HO#0I34$]/3"!/1D8-"@T*#0H-"@T*#0H-"@T*#0H-"@T*#0H-"@T*
$#0H-"@``


`


end

Received on Mon Sep 21 1998 - 09:24:55 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US