I have a list of page URL's in my database table under the column heading URL. There are many different prefixes on each page name for example:
Test1/Admin/Page7.asp Test1/One/Page3.asp Test1/Another/Page2.asp Testing1/Admin2/Page12.asp
Currently I have created some SQL to get a distinct list of the above URL's. However what i need is just the page names. I need to get rid of any text before the last "/". How would I be able to do this within Oracle?
My SQL currently looks something like this:
SELECT DISTINCT URL FROM TABLE1 WHERE URL IS NOT NULL ORDER BY TABLE1.URL