换一种写法吧。现在这样只能在存储过程中用。
insert into tab1 (tablename,tabledef) select table_name,comments from user_tab_comments where table_name not in (select tablename from tab1);
delete tab1 where tablename not in (select table_name from user_tab_comments);
回一楼:好像不是换行的问题,我单行加分号也不行,
我要执行的sql语句是:
begin
for i in (select * from user_tab_comments where table_name not in (select tablename from tab1)) loop insert into tab1 (tablename,tabledef) values (i.table_name,i.comments);
end loop;
delete tab1 where tablename not in (select table_name from user_tab_comments);
end;
放在事物里面好像也不行