SQL> SELECT
extract(
xmltype('<Emp ID="150" LAST_NAME="Tucker"><Dept>80</Dept><Salary>10000</Salary></Emp>'), 'Emp/Salary') salary
2 FROM dual
3 /
SALARY
--------------------------------------------------------------------------------
<Salary>10000</Salary>
SQL>