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

Home -> Community -> Usenet -> c.d.o.server -> Help with a SQL statement

Help with a SQL statement

From: <stuco_at_mailcity.com>
Date: Tue, 15 Sep 1998 19:22:26 GMT
Message-ID: <6tmepg$l5g$1@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 Received on Tue Sep 15 1998 - 14:22:26 CDT

Original text of this message

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