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 -> SQL: put numbers of rows in a variable

SQL: put numbers of rows in a variable

From: Dick Segers <d.segers_at_kpn.com>
Date: Tue, 02 Nov 1999 13:29:57 GMT
Message-ID: <381fe6ef.19087168@dick.at.office> 





Hi there,



From some tables in my database I want to know the number of rows. 
So I use: 



SQL> Select count(*) from tablename;



But now I want to fetch the result in a variable ( so I can make some
readable output )






When that is done I want to make an overview of all user_tables with
there number of rows. 





Thanks in advance,



Dick Segers.

Received on Tue Nov 02 1999 - 07:29:57 CST












Original text of this message













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