SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove Directory Name File Name

we44748079Feb 9 2012 — edited Feb 9 2012

Hi

Col1 contain data as followins

dir/dir2/dir3/filename.ext
dir/filename1.ext
dir2/dir5/filename4.ext
dir6/filename8.ext

I wish to create a query that remove the all dir path from file name and return as follows.

filename.ext
filename1.ext
filename4.ext
filename8.ext

Wishes
J a w a d

This post has been answered by jeneesh on Feb 9 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2012

Added on Feb 9 2012

4 comments

877 views