利用帆软模拟油井示工图,发现帆软的散点图并不是按照数据的排序来连线的,而是按照点相近的大小来连线,导致如果不对示工图的位移点做数学算法排列形成的是面积图(附件有图),我们利用数学方法重新排列分成了上下两个方(附件有图),但是没法完成接口闭合请问有什么方法么,点位重组的SQL算法如下SELECT x_col, y_col, CASE WHEN rownum <=** THEN '上方' ELSE '下方' END wz FROM (WITH t1 AS (SELECT * FROM TABLE(GET_COORDINATES(p_jh => (SELECT jh FROM (SELECT t.jh, csrq, ROW_NUMBER() OVER (ORDER BY csrq DESC) rn FROM dca01 t WHERE jh = 'N3-4-***' AND ROWNUM <= 2) WHERE rn = 2), p_csrq => (SELECT csrq FROM (SELECT t.jh, csrq, ROW_NUMBER() OVER (ORDER BY csrq DESC) rn FROM dca01 t WHERE jh = 'N3-4-***' AND ROWNUM <= 2) WHERE rn = 2)))) SELECT x_col, y_col, rn FROM t1, (SELECT min(rn) minrow FROM (SECT * FROM TABLE(GET_COORDINATES(p_jh => (SELECT jh FROM (SELECT t.jh, csrq, ROW_NUMBER() OVER (ORDER BY csrq DESC) rn FROM dca** t WHERE jh = 'N3-4-****' AND ROWNUM <= 2) WHERE rn = 2), p_csrq => (SELECT csrq FROM (SELECT t.jh, csrq, ROW_NUMBER() OVER (ORDER BY csrq DESC) rn FROM dca01 t WHERE jh = 'N3-4-****' AND ROWNUM <= 2) WHERE rn = 2)))) t WHERE x_col = 0) zero_rowORDER BY (CASE WHEN rn >= minrow THEN 1 ELSE 2 END), rn;