sql
LaLaLaworld
骑上我心爱的小摩托,代码它不会堵车
展开
-
表被锁定的解决办法
1、查看被锁表进程SELECT /*+ rule*/a.sid, b.owner, object_name, object_typeFROM v$lock a, all_objects bWHERE TYPE = 'TM'and a.id1 = b.object_id;2、查被锁定这个对象的用户,使用上一步的sidselect spid, osuser, s.programfrom v$session s,v$process pwhere s.paddr=p.addr and s.sid原创 2022-03-30 16:40:01 · 568 阅读 · 0 评论 -
Oracle修改SEQUENCE起始值
SELECT MAX(T.L_INPUT_NO) FROM TCHECK t;操作例如select SeqCheckInputNo.Nextval from dual;执行:ALTER SEQUENCE SeqCheckInputNo INCREMENT BY 213827;执行:SELECT SeqCheckInputNo.NEXTVAL FROM DUAL;执行:ALTER SEQUENCE SeqCheckInputNo INCREMENT BY 1;...原创 2022-03-30 16:37:08 · 1335 阅读 · 0 评论 -
sql-tips
查询某字段为空的数据时,不能用 = null或 !=null错误示范(查不出数据)select * from table where column != null;正确示范select * from table where column is not null; select * from table where column is null;原创 2022-02-10 14:24:48 · 475 阅读 · 0 评论