select a.position.point_VA.point.x from sdhne a where a.sdhne_id='1001' ......
试试这样(没测试过): select rownum id,a.position[id-1].x from sdhne a where a.sdhne_id='1001' and rownum<65 这种情况嵌套表应该要来得简单。
select rownum id,a.position[id-1].x from sdhne a where a.sdhne_id='1001' and rownum<65 有语法错误
SQL> select SDHNE_ID,SDHNE_TEXT,SDHNE_STATUS,CLASS,JAVACLASS,PARENT,a.x,a.y from sdhne,table(position) a; SDHNE_ID SDHNE_TEXT SDHNE_STATUS CLASS JAVACLASS PARENT X Y --------------------------------------- -------------------------------------------------------------------------------- ------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------- ---------- ---------- 1001 name 10 ilog iii 1 400 500
from sdhne a
where a.sdhne_id='1001'
......
select rownum id,a.position[id-1].x
from sdhne a
where a.sdhne_id='1001'
and rownum<65
这种情况嵌套表应该要来得简单。
from sdhne a
where a.sdhne_id='1001'
and rownum<65
有语法错误
--------------------------------------- -------------------------------------------------------------------------------- ------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------- ---------- ----------
1001 name 10 ilog iii 1 400 500