05 2014 档案

oracle 查看一个表中的记录是否被锁住
摘要：SELECT a.object_id, a.session_id, b.object_nameFROM v$locked_object a, dba_objects bWHERE a.object_id = b.object_id 阅读全文
posted @ 2014-05-29 13:58 shisw 阅读(1766) 评论(0) 推荐(0)
查询一个数据库中有几个表引用了其中某个特定表的主键做为其外键
摘要：select t.table_name from user_constraints twhere t.constraint_type='R' and t.r_constraint_namein(select s.constraint_name from user_constraints swhere... 阅读全文
posted @ 2014-05-29 13:57 shisw 阅读(171) 评论(0) 推荐(0)