tlcjbl的博客

CallableStatement的相关用法解疑CallableStatement度娘文本解释CallableStatement 对象为所有的DBMS 提供了一种以标准形式调用已储存过程的方法。拼代码 private static Connection conn = null; private static CallableStatement Service =null; p

开锁select object_id,session_id,locked_mode from v$locked_object;--查看数据库锁select b.OWNER ,b.OBJECT_NAME,l.SESSION_ID,l.LOCKED_MODE from v$locked_object l,dba_objects b where b.OBJECT_ID = l.OBJECT_ID;se

左右空格：update employee set emp_no=rtrim(ltrim(emp_no)) 字符串中空格：--替换字符串'干干广广'中的‘广广’为‘广告’Update employee Set title = replace('干干广广','广广','广告');--替换“aabb jj ”字符串中的“ ”为“”Update employee Set title = replace