; for sysdba/system to check whether XML has been installed or not 

select comp_name from dba_registry where comp_name like '%XML%';

; creat a xmlType table 

create table table_name of XMLtype XMLType store as CLOB; 

; create a directory permission 

grant create any directory to tson; 

; create a directoy 

create directory my_xml as '/home/faculty4/tson/my_xml';