解决方案 »
- ODI整合MYSQL数据源碰到的问题,求高人解答!
- 真晕。不知道怎么写了。
- 求ORACLE UPDATE速度慢解决方法
- 向高手求助form开发的问题
- oracle用户权限问题
- oracle9i中已经建好的表怎么调出生成此表的sql,有了生成表的sql在哪里执行生成新表
- 高分求sql语句删除一个用户下的所有对象
- 我好象配置了Net Configuration Assistant后,SQLPLUS就连接不上了,说ERROR:ORA-12560: TNS: 协议适配器错误该怎么办?
- 存储过程的输入参数的大小怎么定义
- 无法安装oracle!!!
- 多帐套 多数据库
- oracle触发器:报错ora-04091
FROM (SELECT T1.NODE,
NVL(T1.PARENT, T1.THEMECODE) PARENT,
T1.ALIASNAME,
DECODE(T1.LAYERTYPE, 'UnKnown', 'FOLDER', 'LAYER') IMG,//如果这一句的值为LAYER
T1.THEMECODE,
T1.TABLENAME,
T1.LLEVEL,
T1.THEMEID,
T1.SOURCEURI,
T1.INFORMATION,
T1.LAYERTYPE,
T1.FULLCODE
FROM V_GA_DATA_BASIC T1
WHERE T1.STDCODE = ?
AND T1.THEMECODE = ?
AND T1.LLEVEL = ?
AND ((DECODE(T1.LAYERTYPE, 'UnKnown', 'FOLDER', 'LAYER') = 'LAYER' and T1.NODE IN//那么整个sql连上这一句执行,否则去掉这一句
(SELECT LAYERCODE FROM M_USER_LAYER WHERE USERID = ?))
or (DECODE(T1.LAYERTYPE, 'UnKnown', 'FOLDER', 'LAYER') <> 'LAYER'))
ORDER BY T1.MORDER)
WHERE PARENT = ?;
FROM (SELECT T1.NODE,
NVL(T1.PARENT, T1.THEMECODE) PARENT,
T1.ALIASNAME,
DECODE(T1.LAYERTYPE, 'UnKnown', 'FOLDER', 'LAYER') IMG,//如果这一句的值为LAYER
T1.THEMECODE,
T1.TABLENAME,
T1.LLEVEL,
T1.THEMEID,
T1.SOURCEURI,
T1.INFORMATION,
T1.LAYERTYPE,
T1.FULLCODE
FROM V_GA_DATA_BASIC T1
WHERE T1.STDCODE = ?
AND T1.THEMECODE = ?
AND T1.LLEVEL = ?
-- 此处修改
AND ( T1.LAYERTYPE = 'UnKnown'
OR T1.NODE IN (SELECT LAYERCODE FROM M_USER_LAYER WHERE USERID = ?)
)
ORDER BY T1.MORDER)
WHERE PARENT = ?;