SELECT DISTINCT TMC.EBU_COUNTRY_CODE ||
--Adds a leading 0 to Single-Digit Tables
TO_CHAR(DECODE(LENGTH(TMC.LOCATION_TABLE_NR),1,0 || TMC.LOCATION_TABLE_NR, TMC.LOCATION_TABLE_NR)) ||
--Standardizes external codes to Alpha Character
TO_CHAR(DECODE(TMC.TMC_PATH_DIRECTION,'-','N','+','P','P','P','N','N')) ||
--Adds leading 0's to Point Location
TO_CHAR(DECODE(LENGTH(TMC.LOCATION_CODE),4,0||TMC.LOCATION_CODE,3,00||TMC.LOCATION_CODE,2,000||
TMC.LOCATION_CODE,TMC.LOCATION_CODE)) TMC,
TMC.ROAD_DIRECTION
FROM RDF_LINK_TMC TMC
WHERE ROWNUM < 10
ORDER BY 1;