SELECT
'H',
'M',
ROW_NUMBER() OVER (ORDER BY TLR.CARRIER_ID) as ROW_NUM,
TLR.CARRIER_ID,
LRN.FROM_KEY_NUM,
LRN.FROM_LOW_KEY_VALUE,
CASE LRN.FROM_HIGH_KEY_VALUE
WHEN '0' THEN ''
ELSE LRN.FROM_HIGH_KEY_VALUE
END,
LRN.FROM_COUNTRY,
LRN.TO_KEY_NUM,
LRN.TO_LOW_KEY_VALUE,
CASE LRN.TO_HIGH_KEY_VALUE
WHEN '0' THEN ''
ELSE LRN.TO_HIGH_KEY_VALUE
END,
LRN.TO_COUNTRY,
CASE TRD.UNLOAD_MILE_RATE
WHEN '0' THEN ''
ELSE TO_CHAR(TRD.UNLOAD_MILE_RATE,'fm99999.00')
END,
TRD.MAX_STOPS
FROM
TL_RATE TLR, TL_RATE_DETAIL TRD, LANE_RATE_NETWORK LRN
ASKER
CASE TRD.UNLOAD_MILE_RATE
WHEN '0' THEN ''
ELSE TO_NUMBER(TRD.UNLOAD_MILE_RATE,'fm99999.00')
END,
ASKER
CASE TRD.UNLOAD_MILE_RATE
WHEN '0' THEN NULL
ELSE TO_CHAR(TRD.UNLOAD_MILE_RATE,'fm99999.00')
END,
ASKER
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
TRUSTED BY
FYI, if you use SQL*Plus to test the statement, the parser will indicate where the error was found -- a faster way to debug the code.