随笔分类 - plsql

摘要：select * from (select rowtemp.*, rownum rownumtemp from (select u.*, UA.USR_INFO_ID USR_INFO_ID, UA.ID USER_ACCOUNT_ID, UA.USR_CUST_ID, UA.ACCT_BAL, U 阅读全文

posted @ 2017-09-26 17:03 No-心情阅读(910) 评论(0) 推荐(0)

PLSQL锁表之后改如何操作

摘要：(1)查看哪个表被锁select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;(2)查看是哪个session 阅读全文

posted @ 2017-09-18 16:55 No-心情阅读(1835) 评论(0) 推荐(0)