Oracle can do almost as much as Perl but it's not quite there yet!

Select a piece out of a long filename:

0@@

This will pick out the date part of the filename.

http://www.oracle-developer.net/display.php?id=508 oracle-developer.net