Re: PL-SQL Problem

From: Luuk <Luuk_at_invalid.lan>
Date: Sat, 02 Apr 2011 17:21:16 +0200
Message-ID: <4d973ee8$0$41103$e4fe514c_at_news.xs4all.nl>

On 02-04-2011 16:03, Joydeep Chakrabarty wrote:
> set serveroutput on;
> DECLARE
> sqlstr VARCHAR2(1000);
> cnt NUMBER;
> BEGIN
> FOR v_rec IN (SELECT table_name FROM all_tables WHERE OWNER = 'XYZ')
> loop
> sqlstr := 'select count(*) into cnt from ' || v_rec.table_name ;
> -- DBMS_OUTPUT.PUT_LINE(sqlstr);
> EXECUTE IMMEDIATE sqlstr;
> DBMS_OUTPUT.PUT_LINE(v_rec.table_name ||',' || cnt);
> END LOOP;
> END;
set serveroutput on;
DECLARE
   cursor c1 is

      SELECT table_name FROM all_tables WHERE OWNER = 'XYZ';
   cnt        NUMBER := 0;

BEGIN
   FOR v_rec IN c1 loop

        EXECUTE IMMEDIATE 'select count(*) from ' || v_rec.table_name INTO cnt;

       DBMS_OUTPUT.PUT_LINE(v_rec.table_name ||',' || cnt);    END LOOP;
END;

-- 
Luuk

Received on Sat Apr 02 2011 - 10:21:16 CDT