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

Home -> Community -> Usenet -> c.d.o.tools -> Re: select statement

Re: select statement

From: wayne <no_at_email.please.com>
Date: 12 Jun 2001 17:58:27 GMT
Message-ID: <9g5l83$e3m@dispatch.concentric.net> 






> spool /tmp/runthis.sql

> select 'select count(1) from '||table_name||';' from dba_tables;

> spool off

> @/tmp/runthis.sql




He meant he wanted the number of records in each table, not the number of
tables.
Received on Tue Jun 12 2001 - 12:58:27 CDT












Original text of this message













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