https://blog.youkuaiyun.com/wangweiyong136zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/wangweiyong136/article/details/6993233https://blog.youkuaiyun.com/wangweiyong136/article/details/6993233wangweiyong136Sun, 20 Nov 2011 16:42:25 +0800https://blog.youkuaiyun.com/wangweiyong136/article/details/6854002https://blog.youkuaiyun.com/wangweiyong136/article/details/6854002wangweiyong136Sat, 08 Oct 2011 22:54:54 +0800https://blog.youkuaiyun.com/wangweiyong136/article/details/6828426https://blog.youkuaiyun.com/wangweiyong136/article/details/6828426wangweiyong136Wed, 28 Sep 2011 05:43:30 +0800https://blog.youkuaiyun.com/wangweiyong136/article/details/5806300https://blog.youkuaiyun.com/wangweiyong136/article/details/5806300wangweiyong136Thu, 12 Aug 2010 10:58:00 +0800查询时候发现没有数据，或者报错，请检查原因，最简单的方法是一个一个表的找原因，
看下是那个表出现问题，例如：
select distinct a.*, b.status_int as paystatus /*a.sampleback*/
  from v_lis_app_report_sample_info a, t_opr_attachrelation b
 where a.application_id_chr = b.attachid_vchr(+)<]]>https://blog.youkuaiyun.com/wangweiyong136/article/details/5768130https://blog.youkuaiyun.com/wangweiyong136/article/details/5768130wangweiyong136Tue, 27 Jul 2010 10:10:00 +0800ORA-01940:无法删除当前已链接的用户ORA-01940:无法删除当前已链接的用户
删除某个用户时报ORA-01940,是由于该用户还有session连接，因此先用sysdba用户kill该用户session，再删除该用户即可。示例如下：
SQL> drop user NC56 cascade;
drop user NC56 cascade //NC56为数据库用户名
*
ERROR 位于第 1 行:
ORA-01940: 无法]]>https://blog.youkuaiyun.com/wangweiyong136/article/details/5768117https://blog.youkuaiyun.com/wangweiyong136/article/details/5768117wangweiyong136Tue, 27 Jul 2010 10:07:00 +0800Oracle2009-11-30 14:51:35阅读907评论0字号：大中小
drop user ； 仅仅是删除用户，
drop user ×× cascade ；会删除此用户名下的所有表和视图。
user
Specify the user to be dropped. Oracle Database does not drop users whose schemas contain objec]]>https://blog.youkuaiyun.com/wangweiyong136/article/details/5768114https://blog.youkuaiyun.com/wangweiyong136/article/details/5768114wangweiyong136Tue, 27 Jul 2010 10:05:00 +0800文章分类:数据库

(1)查看用户的连接状况
select username,sid,serial# from v$session
------------------------------------------
如下结果：
 
username          sid                serial#
--------------------------]]>