怎样防止表锁定哦?
我在java程序中执行
begin
update t_12580_bus_ticket set state='1' where id in (SELECT id FROM t_12580_bus_ticket
WHERE to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') < to_char(to_date(create_time, 'yyyy-mm-dd hh24:mi:ss')+numtodsinterval(10,'minute'),'yyyy-mm-dd hh24:mi:ss')
);
commit;
end
后,总是把t_12580_bus_ticket 表给锁定了,请问下,是不是这个sql写的有问题哦?