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> CREATE INDEX by_name
2 ON myTable f (
3 SUBSTR(
4 SYS.XMLType.getStringVal(
5 SYS.XMLType.extract(f.fall,'/fall/name/text()')
6 ),1,80
7 )
8 );
Index created.
SQL>
SQL> drop table myTable;
Table dropped.
SQL>