title: row count of columns with NUMBER datatype only using dynamic sql in oracle
body: <p>I just did the count of rows only for every table in the schema.
  Now I need the row count of columns in tables that have datatype NUMBER.
  I don't know how to get the row count of individual NUMBER datatype columns of every table ? </p>
  
  <pre><code>DECLARE
    t_c1_tname user_tables.table_name%TYPE;
    t_command  VARCHAR2(200);
    row_count INTEGER;
    CURSOR c1 IS SELECT table_name FROM user_tables ORDER BY table_name;
  BEGIN 
    OPEN c1;
    LOOP
          FETCH c1 INTO t_c1_tname;
          EXIT WHEN c1%NOTFOUND;
          t_command  := 'SELECT COUNT(*) FROM '||t_c1_tname ;
          execute immediate t_command into  row_count;
          dbms_output.put_line('Table : '|| t_c1_tname || 'Count : '|| row`enter code here`_count);
    END LOOP;
    CLOSE c1;
  END;
  </code></pre>