SQL> DECLARE
CURSOR C1
IS
SELECT object_name
FROM all_objects
WHERE owner ='SCOTT'
AND object_type ='TABLE'
ORDER BY object_name;
rows INTEGER ;
BEGIN
FOR irec IN c1
LOOP
EXECUTE immediate 'SELECT COUNT(*) FROM '||irec.object_name INTO rows;
dbms_output.put_line(irec.object_name||' = '||TO_CHAR(rows));
END LOOP;
END;
DECLARE
CURSOR C1
IS
SELECT object_name
FROM all_objects
WHERE owner ='SCOTT'
AND object_type ='TABLE'
ORDER BY object_name;
rows integer ;
v_sql varchar2(4000);
BEGIN
FOR irec IN c1
loop
v_sql:= 'SELECT COUNT(*) FROM '||irec.object_name ;
EXECUTE immediate v_sql into rows;
dbms_output.put_line(irec.object_name||' = '||TO_CHAR(rows));
END LOOP;
END;
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.
Comments (0)