ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
http://www.experts-exchange.com/Database/Oracle/Q_24914739.html?#a25864822
SELECT
RTRIM(
EXTRACT(XMLAGG(XMLELEMENT(
'||'
)
column3
FROM yourtable
;