问一个SQL的语句

Question

不知可否使用select position.x from sdhne

Answer 1

select  a.position.point_VA.point.x 
from    sdhne a
where   a.sdhne_id='1001'
......

Answer 2

试试这样（没测试过）：
select  rownum id,a.position[id-1].x 
from    sdhne a
where   a.sdhne_id='1001'
and     rownum<65
这种情况嵌套表应该要来得简单。

Answer 3

select  rownum id,a.position[id-1].x 
from    sdhne a
where   a.sdhne_id='1001'
and     rownum<65
有语法错误

Answer 4

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