PL/SQL dev工具 使用for update-->Edit Date 时出错"These query results are not updateable,Include the ROWID to get updateable results."
<br />select * from table where tablecode = '001' for update;--如果执行这条语句,执行Edit Date时,报错"These query results are not updateable,Include the ROWID to get updateable results."要加RowID,修改sql如下:<br />select c.*,c.rowid from table c where tablecode = '001' for up
原创
2010-10-28 14:56:00 ·
1696 阅读 ·
0 评论