SELECT ID, CODE, SUBSTR(CODE, 3, 4), CHANNEL_TYPE
FROM DRP.DISTR_CHANNEL
WHERE CHANNEL_TYPE = 'M7' <--- 手动输入参数
AND SUBSTR(CODE, 1, 2) = [color=red] CHANNEL_TYPE[/color]
FROM DRP.DISTR_CHANNEL
WHERE CHANNEL_TYPE = 'M7' <--- 手动输入参数
AND SUBSTR(CODE, 1, 2) = [color=red] CHANNEL_TYPE[/color]