oracle 常用脚本语句

1、修改时间字段

UPDATE UOS_STAFF_IOM us SET pwd_mod_date= to_date('2022-10-22 00:00:00','yyyy-MM-dd hh24:mi:ss') where staff_id = 3078 ;

select * from UOS_STAFF_IOM where staff_id = 3078 for update ;

UPDATE UOS_STAFF_IOM us SET pwd_mod_date= SYSDATE where staff_id = 3078 ;

2、rowid      for  update   行锁修改

select rowid,usi.* from UOS_STAFF_IOM usi where staff_id = 3078 for update ;