|
SQL>
SQL> create table my_xml_docs
2 ( id number primary key,
3 xmldoc varchar2(4000)
4 )
5 /
Table created.
SQL>
SQL>
SQL> insert into my_xml_docs( id, xmldoc )
2 values( 1,
3 '<appointment type="personal">
4 <title>T</title>
5 <start_date>31-MAR-2001</start_date>
6 <start_time>11:00</start_time>
7 <notes>Review</notes>
8 <attendees>
9 <attendee>J</attendee>
10 <attendee>T</attendee>
11 </attendees>
12 </appointment>' )
13 /
1 row created.
SQL>
SQL> drop table my_xml_docs;
Table dropped.
|