17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT COUNT(*)
INTO ptnum
FROM tb_spatial c
WHERE
fun_detect_pt_in_line(x,y) =1
AND
SDO_WITHIN_DISTANCE(c.shape,v_geopolyline,'distance=100,unit=m')='TRUE';
SELECT COUNT(*)
INTO ptnum
FROM
(
SELECT x,y
FROM tb_spatial c
WHERE SDO_WITHIN_DISTANCE(c.shape,v_geopolyline,'distance=100,unit=m')='TRUE'
)
WHERE fun_detect_pt_in_line(x,y) =1;