源字符串
3047002000
3047000200
3047011200
SELECT
SUBSTR(DEVICE_NO,1,4) as DISTRICT_ID,
REGEXP_REPLACE(SUBSTR(DEVICE_NO,5,4),'^0+','') as ADDRESS_ID,
PHASE,
EE_KWH,
RECORD_DATE,
SEGMENT_ID
FROM T_MEASURE_RECORD
SELECT
SUBSTR(DEVICE_NO,1,4) as DISTRICT_ID,
REGEXP_REPLACE(SUBSTR(DEVICE_NO,5,4),'^0+','') as ADDRESS_ID,
PHASE,
EE_KWH,
RECORD_DATE,
SEGMENT_ID
FROM T_MEASURE_RECORD