1、1.查看锁表
SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,
l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS
FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID;
2、删除表记录
DELETE FROM tablename;
3、修改为当前时间戳
update tablename set vc_timestamp = to_char(systimestamp, 'yyyymmddhh24missff6');
4、表之间关联删除
delete A
from A ,B
where A.CID=B.CID and B.cp = 2;
or
delete A
from A
inner join B
on A.CID=B.CID
where B.cp = 2;
5、设置表字段值
update 表名 set 字段='要修改后的值' where 定位字段='值'
