Oracle查询sechme下所有表的总记录

DECLARE  
  v_count NUMBER;  
BEGIN  
  FOR t IN (SELECT table_name FROM user_tables) LOOP  
    EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || t.table_name INTO v_count;  
    DBMS_OUTPUT.PUT_LINE(t.table_name || ': ' || v_count);  
  END LOOP;  
END;