Oracle 读取XML并将其存储在本地临时表中，然后从临时表中选择数据进行操作

SQL> create table t ( x xmltype);

Table created.

SQL>
SQL> declare
  2    my_xml clob :=
  3   '
  4   https://toitest1.servicebus.net/oracle1
  5   
  6   2016-11-30T19:32:43Z
  7   2017-05-02T14:43:51Z
  8   toitest1
  9   
 10   
 11   PT30S
 13       16384
 14       false
 15       false
 16       P14D
 17       false
 18       PT10M
 19       10true
 20       357
 21       1
 22   
 23   
 24   ';
 25
 26  begin
 27    insert into t values ( xmltype(my_xml));
 28  end;
 29  /

PL/SQL procedure successfully completed.
复制