ORACLE
weijlxm
我要考研!!!
展开
-
Oracle数据库查看用户锁表和对表解锁的sql语句
① 查看用户锁表select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_objects ao, v$session sess where ao.object_id = lo.ob...转载 2018-10-12 15:09:01 · 6023 阅读 · 0 评论 -
fetch out of sequence sqlcode = -1002 异常原因和解决方法
1.sqlcode = -1002 异常原因官方解释:ORA-01002: fetch out of sequence Cause: In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issu...原创 2018-11-04 16:04:43 · 5837 阅读 · 0 评论