oops, remove the -1 select b.name , a.table_name , a.num_rows from user_tables a , arschema b where tablespace_name = 'ARSYSTEM' and TO_CHAR(b.schemaid) = SUBSTR(a.table_name,2,LENGTH(a.table_name)) and table_name like 'T%'
Axton Grams On Feb 19, 2008 10:19 AM, Axton <[EMAIL PROTECTED]> wrote: > select b.name > , a.table_name > , a.num_rows > from user_tables a > , arschema b > where tablespace_name = 'ARSYSTEM' > and TO_CHAR(b.schemaid) = SUBSTR(a.table_name,2,LENGTH(a.table_name)-1) > and table_name like 'T%' > > Axton Grams > > > On Feb 19, 2008 10:09 AM, Toby White <[EMAIL PROTECTED]> wrote: > > > ** Thanks Jarl > > > > Would it be possilbe to extend the statements to relate the T table > > numbers to the arschema table. > > > > Cheers > > Toby > > > > > > On 19/02/2008, Jarl Grøneng <[EMAIL PROTECTED]> wrote: > > > > > > You can do it the hard way and loop trough and count all the tables, > > > or you can query the user_tables table. > > > > > > select table_name, num_rows from user_tables where tablespace_name = > > > 'ARSYSTEM' > > > > > > > > > Regards, > > > Jarl > > > > > > On Feb 19, 2008 11:29 AM, Toby White <[EMAIL PROTECTED]> wrote: > > > > ** > > > > > > > > Hi > > > > > > > > Does anyone know how I can count the number of records in each form > > > on an > > > > Oracle database. I searched the list and found the way to do it > > > using SQL > > > > Server but stuck on getting the solution for Oracle. > > > > > > > > Thanks > > > > Toby __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the > > > Answers Are" > > > > html___ > > > > > > > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"