Save value returned from DBMS_METADATA.GET_XML to xmltype : DBMS_METADATA « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. DBMS_METADATA

Save value returned from DBMS_METADATA.GET_XML to xmltype

 

SQL> create table myTable
  2  (myID  number primary key,
  3  ddl     xmltype );

Table created.

SQL>
SQL> create index all_idx on myTable(extractvalue(ddl,'/ROWSET/ROW/TABLE_T/SCHEMA_OBJ/NAME'))
  2
SQL> insert into myTable values (1,xmltype((SELECT DBMS_METADATA.GET_XML('TABLE','emp','java2s')FROM DUAL)))
  2  select index_name, index_type from user_indexes
  3  where table_name = 'myTable'
  4
SQL> drop table myTable;

Table dropped.

SQL>

   
  

Related examples in the same category