title: How do I get the number of rows in each table I have in my oracle database
body: <p>Can someone tell me how I can get the number of rows in each table in my oracle database? I have found several queries, but none of them worked because I am using oracle 7 and sql<em>plus 3.2 and basically all what I found didn't work on it. I just need something that would work on sql</em>plus 3.2.</p>
  
  <p>Required:</p>
  
  <p>Table Name          Rows</p>
  
  <p>Table 1               0</p>
  
  <p>Table 2               5</p>
  
  <p>...</p>
  
  <p>Is it possible to do it with something like a loop? Or what exactly should I do?</p>