SQL>
SQL> CREATE TABLE myTable (
2 fall_id NUMBER,
3 fall SYS.XMLType
4 );
Table created.
SQL>
SQL> INSERT INTO myTable VALUES (1, SYS.XMLType.CreateXML(
2 '
3
4 myTable
5 USA
6 MI
7
8 http://your.com
9
10 '));
1 row created.
SQL>
SQL> INSERT INTO myTable VALUES (2, SYS.XMLType.CreateXML(
2 '
3
4 Au myTable
5 USA
6 MI
7
8 http://your.com
9
10 '));
1 row created.
SQL>
SQL> INSERT INTO myTable VALUES (3, SYS.XMLType.CreateXML(
2 '
3
4 myTable
5 USA
6 MI
7 '));
1 row created.
SQL>
SQL> drop table myTable;
Table dropped.
SQL>