当满足某些条件的时候,从ab01_t中取数据
解决方案 »
- win7下oracle安装出现的问题
- 调整SGA大小后数据库起不起来了??急!!!!
- 这样的数据怎么查?小弟在线求解决!
- ======急救====:我的全文索引出问题了!
- oracle动态存储的数据操作(DML)问题
- 我从Oracle网站上下载的10g 10.1.0.2.0,它的许可是怎样规定的?
- 安装oracle817后,系统多了好几个服务,是作什么用的。
- 关于从SQLSERVER中转入到ORACLE中的问题
- 很简单的求救!?oracle designer
- 用JDBC连ORACLE,这个JDBC的环境要用什么呢,JSWDK?JAVA WEB SERVER?好象有很多可以的,菜菜迷茫ING
- 再来一贴,我创建的存储过程PLS-00905: 对象 JTJ.CARINFO 无效,帮忙看看
- 100分求救用户PLSQL Developer管理ORACLE时候如何在登陆的时候能记住数据库的用户名和密码?
(select 1 from t_operatorinfo
where sys_flat=1
and operator_id=(SELECT client_info from v$session b
where b.audsid=to_number(USERENV('SESSIONID'))))
---------USERENV函数返回当前用户环境的信息
or aab001 in
(select aab001 from t_user_privs
where operator_id=(SELECT client_info from v$session b
where b.audsid=to_number(USERENV('SESSIONID'))))
OR '900' = (SELECT client_info from v$session b
where b.audsid=to_number(USERENV('SESSIONID')))
只是语句看起来乱点,思路还是么清晰的
exists
(select 1 from t_operatorinfo
where sys_flat=1
and operator_id=(SELECT client_info from v$session b
where b.audsid=to_number(USERENV('SESSIONID'))))
or
( ----------新增
aab001 in
(select aab001 from t_user_privs
where operator_id=(SELECT client_info from v$session b
where b.audsid=to_number(USERENV('SESSIONID'))))
OR '900' = (SELECT client_info from v$session b
where b.audsid=to_number(USERENV('SESSIONID')))
) ----------新增
表v$session其中各个字段都是什么意思,具体些????????????
还有USERENV('SESSIONID')什么函数,具体些?????????????????????其实不只是你们晕,我看了都快疯了,这就是东软写的东西!谁能具体回答我的问题呀!!!???????????????????????????????????????????????????
client_info 字段应该是客户端发出的信息,应该是软件中某项功能实现的写入。
至于写的是什么,还要看软件的逻辑。
http://tahiti.oracle.com/,查找sys_context,自行了解相关信息。不知道表结构,没有设计文档,谁能解释语句的含义呢??
表v$session其中各个字段都是什么意思,具体些????????????
还有USERENV('SESSIONID')什么函数,具体些?????????????????????其实不只是你们晕,我看了都快疯了,这就是东软写的东西!谁能具体回答我的问题呀!!!???????????????????????????????????????????????????
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2088.htm#sthref3985
where b.audsid=to_number(USERENV('SESSIONID'))))
英文解释看不懂,还是直接点谁能告诉我v$session 视图中的audsid字段是什么意思?有什么作用?
再有就是USERENV('SESSIONID')是什么函数?
最好具体点?????????????????????
"AAB002",
"AAB003",
"AAB004",
"ZAB001",
"AAB005",
"AAE006",
"CAB002",
"CAB003",
"AAE007",
"AAB006",
"AAB007",
"AAB008",
"AAB009",
"AAB010",
"AAB011",
"AAB012",
"AAB013",
"AAB014",
"AAB015",
"AAB016",
"AAB017",
"AAB018",
"AAB019",
"AAB020",
"AAB021",
"AAB022",
"AAB023",
"AAB024",
"AAB025",
"AAB026",
"AAB027",
"AAB028",
"AAB029",
"AAB030",
"AAB031",
"AAB032",
"AAB033",
"AAB034",
"AAB035",
"AAB036",
"AAE119",
"AAB038",
"AAB039",
"CKB050",
"CKB052",
"CKB053",
"AAE011",
"AAE036",
"CAB001",
"CKB073",
"CKB100",
"AAE013",
"CAB005",
"CAB004",
"CAB008",
"CAB011",
"CIC054",
"CIB011",
"CKB150",
"CKB151",
"AAB901",
"AAB040",
"AAB041",
"AAB042",
"AAB043",
"AAB044",
"AAB045"
from ab01_t
where exists
(select 1
from t_operatorinfo
where sys_flat = 1
and operator_id =
(SELECT client_info
from v$session b
where b.audsid = to_number(USERENV('SESSIONID'))))
or aab001 in
(select aab001
from t_user_privs
where operator_id =
(SELECT client_info
from v$session b
where b.audsid = to_number(USERENV('SESSIONID'))))
OR '900' = (SELECT client_info
from v$session b
where b.audsid = to_number(USERENV('SESSIONID')))---------------------为什么不排下版
不过业务逻辑很复杂