WITH tab_transformation AS
(SELECT a.id_transformation, a.id_directory, a.name, b.directory_name
FROM r_transformation a
LEFT JOIN r_directory b
ON a.id_directory = b.id_directory
WHERE a.id_directory IN
(SELECT m.id_directory
FROM (SELECT a.id_directory,
a.directory_name,
a.id_directory_parent,
LEVEL nu_level
FROM r_directory a
START WITH a.directory_name IN
('业绩归属', '合同信息', '客户信息', '报价信息', '收益信息', '数据留存',
'项目信息', '用户信息')
CONNECT BY PRIOR a.id_directory = a.id_directory_parent) m
WHERE m.directory_name NOT IN
('转换', '作业', '存储过程', 'SRC_RPT_HETQDXX', '合同清单信息_运通宝'))
AND a.name NOT LIKE '%存储过程%'
AND a.id_directory <> '51')
SELECT n.directory_name, n.name, m.value_str
FROM r_step_attribute m
INNER JOIN tab_transformation n
ON m.id_transformation = n.id_transformation
WHERE m.code = 'sql'
ORDER BY n.directory_name, n.name
这就是sql。直接查的数据源。数据源都是正常的 |