关于一个在下列结果SQL中增加字段和注释
0
SELECT /*+no_merge*/T1.OWNER||'.'||T1.NAME,T1.*
FROM ALL_SOURCE T1
WHERE T1.TYPE LIKE '%PROCEDURE%'
AND T1.NAME IN
(SELECT T2.NAME
FROM DBA_DEPENDENCIES T2
WHERE T2.REFERENCED_NAME = 'DWA_V_M_CUS_MB_SING_VOICE') AND
EXISTS (SELECT 1 FROM TEST_TABLE2 T3 WHERE T1.TEXT LIKE '%'|| T3.COLUMN_NAME||'%' );
TEST_TABLE2是自己构建一个包含自己想要的字段和注释,上面的是SQL是找出依赖这个表的字段存储过程内容,我想在这个表上结果上TEST_TABLE2的字段和注释
FROM ALL_SOURCE T1
WHERE T1.TYPE LIKE '%PROCEDURE%'
AND T1.NAME IN
(SELECT T2.NAME
FROM DBA_DEPENDENCIES T2
WHERE T2.REFERENCED_NAME = 'DWA_V_M_CUS_MB_SING_VOICE') AND
EXISTS (SELECT 1 FROM TEST_TABLE2 T3 WHERE T1.TEXT LIKE '%'|| T3.COLUMN_NAME||'%' );
TEST_TABLE2是自己构建一个包含自己想要的字段和注释,上面的是SQL是找出依赖这个表的字段存储过程内容,我想在这个表上结果上TEST_TABLE2的字段和注释
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
老头子 - 专注是唯一的捷径 2016-10-24 回答
赞同来自: 夏尔康 、GeorgeYao
FROM ALL_SOURCE T1 left join TEST_TABLE2 T3 on T1.TEXT LIKE '%'|| T3.COLUMN_NAME||'%'
WHERE T1.TYPE LIKE '%PROCEDURE%'
AND T1.NAME IN
(SELECT T2.NAME
FROM DBA_DEPENDENCIES T2
WHERE T2.REFERENCED_NAME = 'DWA_V_M_CUS_MB_SING_VOICE')
AND T3.COLUMN_NAME IS NOT NULL