17,082
社区成员
发帖
与我相关
我的任务
分享oracle xmlquery
select xmlquery('<Manifest>
{for $vv in ora:view("vessel_visit")/ROW where $vv/ID = "1FB017A696A54F62B656481D975417C6"
return
<RepresentativePerson>{$vv/CREATED_BY}</RepresentativePerson>
}
</Manifest>'
returning content)
high_commission_emp_names
from dual;
-----------------------------
有谁知道怎么给CREATED_BY字段加别名吗?
{for $vv in ora:view("vessel_visit")/ROW where $vv/ID = "1FB017A696A54F62B656481D975417C6"
return
<RepresentativePerson>{$vv/CREATED_BY}</RepresentativePerson>
}
</Manifest>'
returning content)
high_commission_emp_names
from dual;
-----------------------------
有谁知道怎么给CREATED_BY字段加别名吗?
...全文
请发表友善的回复…
发表回复
zxg643725386 2019-09-03
- 打赏
- 举报
