这个语句为什么在oracle中执行总是报错？？要怎么改呢？

Question

SELECT
T4.DEPT_NAME 部门名称,
T4.DATA_SOURCE_NAME 系统名称,
T4.TAB_ID 标准层表ID,
T4.TAB_NAME 标准层表名,
T4.TAB_DESC 标准层表描述,
T2.COL_NAME AS 贴源层列名,
T2.COL_DESC AS 贴源层列描述,
T1.TRG_COL_ID AS 标准层列ID,
T4.COL_NAME AS 标准层列名称,
t4.COL_TYPE 标准列类型,
t4.LENGTH 标准列长度,
t4.PRECISION 标准列精度,
t4.NULLABLE 标准列是否为空,
T1.RULE_ID 规则ID,
T1.statement_rule 实际的表达式规则,
T1.CODE_RULE 实际的映射规则,
T5.RULE_ID AS 实际映射规则ID,
T5.SRC_CODE_TYPE_ID 源编码类型ID,
T5.SRC_CODE_TYPE_NAME 源编码类型名称,
T5.SRC_CODE_TYPE_DESC 源编码类型描述,
T5.SRC_STANDARD_ID 源编码类型引用标准编码ID（数据图书馆）,
T5.SRC_STANDARD_NAME 源编码类型引用标准编码名称（数据图书馆）,
T5.SRC_STANDARD_TYPE_ID 源编码类型引用标准编码类型（数据图书馆）,
T5.SRC_STANDARD_DESC 源编码类型引用标准编码描述（数据图书馆）,
T5.STD_CODE_TYPE_ID 标准编码类型ID,
T5.STD_CODE_TYPE_NAME 标准编码类型名称,
T5.STD_CODE_TYPE_DESC 标准编码类型描述,
T5.STD_STANDARD_ID 标准编码类型引用标准编码ID（数据图书馆）,
T5.STD_STANDARD_NAME 标准编码类型引用标准编码名称（数据图书馆）,
T5.STD_STANDARD_TYPE_ID 标准编码类型引用标准编码类型ID（数据图书馆）,
T5.STD_STANDARD_DESC 标准编码类型引用标准编码描述（数据图书馆）,
T6.RULE_NAME 原始函数规则名称,
T6.RULE_DESC 原始函数规则描述,
T6.RULE_EXPR 原始函数规则表达式
FROM
DIM_COL_MAPPING T1
INNER JOIN
(SELECT * FROM
DIM_TAB_COLS T2
WHERE T2.VALID_FLAG = '1') T2
ON (T1.SRC_COL_ID = T2.COL_ID)
INNER JOIN
(SELECT
T4.DEPT_NAME,
T3.DATA_SOURCE_NAME,
T1.TAB_ID,
T2.TAB_NAME,
T2.TAB_DESC,
T1.COL_ID,
T1.COL_NAME,
T1.COL_DESC,
t1.COL_TYPE ,
t1.LENGTH ,
t1.PRECISION ,
t1.NULLABLE
FROM
DIM_TAB_COLS T1,
DIM_DATA_TAB_REG T2,
DIM_DATA_SOURCE T3,
DIM_DEPT_INFO T4
WHERE T1.TAB_ID = T2.TAB_ID
AND T2.TAB_SYS_ID = T3.DATA_SOURCE_ID
AND T3.DEPT_ID = T4.DEPT_ID
AND T1.VALID_FLAG = '1'
AND T2.VALID_FLAG = '1'
AND T3.VALID_FLAG = '1'
AND T4.VALID_FLAG = '1'
AND T2.TAB_LAYER_ID = '2') T4
ON (T1.TRG_COL_ID = T4.COL_ID)
LEFT JOIN
(SELECT
T9.DATA_SOURCE_ID,
T8.RULE_ID,
T8.RULE_EXPR,
LEFT(T8.RULE_EXPR, INSTR(T8.RULE_EXPR, ':') - 1) SRC_CODE_TYPE_ID,
T9.CODE_TYPE_NAME AS SRC_CODE_TYPE_NAME ,
T9.CODE_TYPE_DESC AS SRC_CODE_TYPE_DESC,
T9.STANDARD_ID AS SRC_STANDARD_ID,
T9.STANDARD_NAME AS SRC_STANDARD_NAME,
T9.STANDARD_TYPE_ID AS SRC_STANDARD_TYPE_ID ,
T9.STANDARD_DESC AS SRC_STANDARD_DESC,
RIGHT(T8.RULE_EXPR, LENGTH(T8.RULE_EXPR)-INSTR(T8.RULE_EXPR, ':') ) STD_CODE_TYPE_ID ,
T10.CODE_TYPE_NAME AS STD_CODE_TYPE_NAME,
T10.CODE_TYPE_DESC AS STD_CODE_TYPE_DESC,
T10.STANDARD_ID AS STD_STANDARD_ID,
T10.STANDARD_NAME AS STD_STANDARD_NAME,
T10.STANDARD_TYPE_ID AS STD_STANDARD_TYPE_ID ,
T10.STANDARD_DESC AS STD_STANDARD_DESC
FROM
DIM_COMM_RULE T8 ,
DIM_CODE_TYPE T9,
DIM_CODE_TYPE T10
WHERE LEFT(T8.RULE_EXPR, INSTR(T8.RULE_EXPR, ':') - 1)=T9.CODE_TYPE_ID
AND RIGHT(T8.RULE_EXPR, LENGTH(T8.RULE_EXPR)-INSTR(T8.RULE_EXPR, ':') )=T10.CODE_TYPE_ID
AND T8.RULE_TYPE_ID = '2'
AND T8.VALID_FLAG='1'
AND T9.VALID_FLAG='1') T5
ON (T1.CODE_RULE=T5.RULE_EXPR)
LEFT JOIN
(SELECT * FROM DIM_COMM_RULE T6 WHERE T6.RULE_TYPE_ID='1' AND T6.VALID_FLAG='1')T6
ON(T1.RULE_ID=T6.RULE_ID)

WHERE T1.VALID_FLAG = '1'
AND (
T1.STATEMENT_RULE IS NOT NULL
OR T1.CODE_RULE IS NOT NULL
)

Answer 1

你分拆出来，执行呀。先看每个子查询有没有问题