Wario,
thank you very much!
sergeant.rock_at_gmail.com (Wario) wrote in message news:<c75b43bb.0409010603.40a975ff_at_posting.google.com>...
> Try This:
>
> declare
> cursor u_tab is select table_name from user_tables;
>
> begin
> execute immediate 'create global temporary table temp_tab1 (
> col_count number)';
>
> for u_tab_rec in u_tab
> loop
> execute immediate 'insert into temp_tab1 select count(*) from
> ' || u_tab_rec.table_name;
>
> end loop;
> end;
Received on Wed Sep 01 2004 - 16:51:30 CDT
