Re: PLS-00306: wrong number or types of arguments in call to '||'
From: Wario <sergeant.rock_at_gmail.com>
Date: 1 Sep 2004 07:03:47 -0700
Message-ID: <c75b43bb.0409010603.40a975ff_at_posting.google.com>
Date: 1 Sep 2004 07:03:47 -0700
Message-ID: <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
execute immediate 'insert into temp_tab1 select count(*) from
' || u_tab_rec.table_name;
end loop;
loop
end;
Received on Wed Sep 01 2004 - 16:03:47 CEST