http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FXML%2FExistsNode
Oracle PL/SQL/XML/ExistsNode - История изменений
2026-04-07T01:08:21Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/XML/ExistsNode&diff=1326&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=Oracle_PL/SQL/XML/ExistsNode&diff=1327&oldid=prev
Admin: 1 версия
2010-05-26T09:55:31Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Count(*) and existsnode()==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> CREATE TABLE myTable<br />
2 (id NUMBER PRIMARY KEY<br />
3 ,doc XMLType NOT NULL)<br />
4 XMLTYPE doc STORE AS CLOB<br />
5 /<br />
Table created.<br />
SQL><br />
SQL> select COUNT(*) from myTable<br />
2 where existsnode(doc, "/message/greeting") = 1<br />
3 /<br />
COUNT(*)<br />
----------<br />
0<br />
1 row selected.<br />
SQL> drop table myTable;<br />
Table dropped.<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==existsnode and where clause==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> create table myTable of xmltype;<br />
Table created.<br />
SQL><br />
SQL> insert into myTable values(XMLTYPE("<br />
2 <customer><br />
3 <name>Chris</name><br />
4 <telephone>123 555-1234</telephone><br />
5 </customer>"))<br />
6 /<br />
1 row created.<br />
SQL><br />
SQL> select * from myTable;<br />
<br />
SYS_NC_ROWINFO$<br />
------------------------------------------------------<br />
<customer><br />
<name>Chris</name><br />
<telephone>123 555-1234</telephone><br />
</<br />
1 row selected.<br />
SQL><br />
SQL> update myTable c<br />
2 set value(c) = updateXML(value(c), "/customer/name/text()","new value")<br />
3 /<br />
1 row updated.<br />
SQL><br />
SQL><br />
SQL> select extractvalue(value(c),"/customer/telephone")<br />
2 from myTable c<br />
3 where existsnode(value(c),"/customer/name = "Chris"") = 1<br />
4 /<br />
no rows selected<br />
SQL><br />
SQL> drop table myTable;<br />
Table dropped.<br />
SQL><br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==existsnode(myValue, "/ROWSET")==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> CREATE TABLE myTable<br />
2 (myID NUMBER PRIMARY KEY,<br />
3 myValue XMLTYPE )<br />
4 XMLTYPE myValue STORE AS CLOB<br />
5 /<br />
Table created.<br />
SQL><br />
SQL> select COUNT(*)<br />
2 from myTable d<br />
3 where existsnode(myValue, "/ROWSET") = 1<br />
4 /<br />
COUNT(*)<br />
----------<br />
0<br />
1 row selected.<br />
SQL><br />
SQL><br />
SQL> drop table myTable;<br />
Table dropped.<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Oracle XML function ExistsNode.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> CREATE TABLE myTable(<br />
2 id NUMBER PRIMARY KEY<br />
3 ,doc XMLType NOT NULL<br />
4 )<br />
5 XMLTYPE doc STORE AS CLOB<br />
6 /<br />
Table created.<br />
SQL><br />
SQL> -- Demo the selfish style of invocation<br />
SQL> select COUNT(*)<br />
2 from myTable x<br />
3 where x.doc.existsnode("/message/greeting") = 1<br />
4 /<br />
COUNT(*)<br />
----------<br />
0<br />
1 row selected.<br />
SQL><br />
SQL> drop table myTable;<br />
Table dropped.<br />
<br />
<br />
</source></div>
Admin