In both statement, you include the trailing semi-colon, which should
not be inserted into your SQL string.
Here is a sample ...
Declare
begin
for i in ( select table_name from user_tables
where table_name in ('T1','T2') loop
execute immediate 'Update '||i.table_name||
' set created_date=sysdate,'||
' last_modified_date=sysdate,'||
' created_userid=''sale'','||
' last_modified_userid=''sale''';
commit;
dbms_output.put_line( 'Updated -> ' || i.tables);
end loop;
end;
/
Received on Wed Apr 20 2005 - 15:30:39 CDT
