Re: Help with complicated select statement

No Such Luck wrote:
> I have a table column, "filename", that stores the names of different
> types of files gathered from the web. Because the files are gathered
> from the web, some of the file names have URL encoded characters, i.e.,
> %20, %22, etc.
>
> I'd like a select statement to scan the data in the column, dynamically
> create the list of hex codes that occur, and tally the number of each
> occurrence.
>
> Something like:
>
> Hex Code: Tally
> %20 17,809
> %22 1,295
> %7E 57

Take a look at the UTL_URL built-in package.

Full documentation is at http://tahiti.oracle.com and demos of its use at www.psoug.org ... click on Morgan's Library and scroll down to UTL_URL.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)