触发器中关于rowid
是这样的,str是定义的变量主要利用表自带的rowid
str:='select * form table1 where rowid='||:new.rowid
execute immediate str;
是这样的,str是定义的变量主要利用表自带的rowid
str:='select * form table1 where rowid='||:new.rowid
execute immediate str;
execute immediate str(str:='select * from table1 where rowid='|| :new.rowid)