SQL语句杂记

最新推荐文章于 2021-02-25 18:50:57 发布

House李

最新推荐文章于 2021-02-25 18:50:57 发布

阅读量527

点赞数

本文链接：https://blog.csdn.net/Miss_payer/article/details/70675134

版权

--查询包含指定列名'IMG_CLS'的表sqlserver
SELECT OBJECT_NAME(object_id) as '表名',name as '列名' from sys.columns where name ='IMG_CLS' --or name ='IMG_FMT' order by OBJECT_NAME(object_id);

--解锁被锁的表格orcle

select b.owner,b.object_name,a.session_id,c.serial#,a.locked_mode from v$locked_object a,dba_objects b，v$session c where b.object_id = a.object_id and a.session_id = c.sid;
alter system kill session'session_id,serial#';