SELECT '电力电缆' AS 设备类型,
A.SBMC || T.SBMC AS 设备名称,
SUBSTR(REGEXP_SUBSTR(TO_CHAR(T.SHAPE), '[^ ]+', 1, LEVEL, 'i'),
1,
INSTR(REGEXP_SUBSTR(TO_CHAR(T.SHAPE), '[^ ]+', 1, LEVEL, 'i'),
',') - 1) AS 经度,
SUBSTR(REGEXP_SUBSTR(TO_CHAR(T.SHAPE), '[^ ]+', 1, LEVEL, 'i'),
INSTR(REGEXP_SUBSTR(TO_CHAR(T.SHAPE), '[^ ]+', 1, LEVEL, 'i'),
',') + 1) AS 纬度
FROM T_TX_ZWYC_DTD T, T_TX_ZWYC_DLD A
WHERE T.SSDLD = A.SBID
CONNECT BY LEVEL <= LENGTH(TO_CHAR(T.SHAPE)) -
LENGTH(REGEXP_REPLACE(TO_CHAR(T.SHAPE), ' ', '')) + 1;
网友评论