![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
c4323098
这个作者很懒,什么都没留下…
展开
-
ORA-01940: cannot drop a user that is currently connected
在本地的测试环境下,打算删除用户重建一下。 SQL> drop user XXXX cascade;drop user pstk cascade*ERROR at line 1:ORA-01940: cannot drop a user that is currently connected SQL> 处理如下: select sid,serial# from v$se...原创 2012-10-03 21:48:22 · 89 阅读 · 0 评论 -
关于oracle中无法查询中文条件的解决方法
1. 检查一个简单的sql = select * from tb_user_master where name = '张三'表中存有该数据,但是检索无结果2.解决方法很简单- SELECT * FROM v$nls_parameters ; 查看NLS_CHARACTERSET 的值是多少,我的AL32UTF8- 查找客户机器的注册表,查找NLS_LANG的值,改成AL32U...原创 2013-09-09 18:52:19 · 894 阅读 · 0 评论