转换前:
DECODE(TRIM(FCA_CASSETTE.PORT_ID),
'',
DECODE(TRIM(FCA_CASSETTE.RACK_ID),
'',
' ',
FCA_CASSETTE.RACK_ID),
FCA_CASSETTE.PORT_ID) AS PORT_RACK_ID_DISP
转换后:
CASE TRIM(FCA_CASSETTE.PORT_ID) WHEN '' THEN CASE TRIM(FCA_CASSETTE.RACK_ID) WHEN '' THEN ' ' ELSE FCA_CASSETTE.RACK_ID END ELSE FCA_CASSETTE.PORT_ID END
转换前:
DECODE((TRIM(FCA_CASSETTE_HOLD.HOLD_COMMENT) || ':' ||
TRIM(FCA_CASSETTE_HOLD.UPDATER)),
':',
'',
(TRIM(FCA_CASSETTE_HOLD.HOLD_COMMENT) || ':' ||
TRIM(FCA_CASSETTE_HOLD.UPDATER)))
转换后:
CASE TRIM(FCA_CASSETTE_HOLD.HOLD_COMMENT) || ':' || TRIM(FCA_CASSETTE_HOLD.UPDATER) WHEN ':' THEN ''
ELSE TRIM(FCA_CASSETTE_HOLD.HOLD_COMMENT) || ':' || TRIM(FCA_CASSETTE_HOLD.UPDATER) END