In Oracle I have a column in one of our tables that shows the file pathway of a given report. However I just need the name of the report to come back to use to connect to another table.

The column can be a string as follows:

```
Report_Name
-----------
Public >> Reports >> Division1 >> Customer Service >> ReportABC
Public >> Reports >> Division2 >> Purchasing >> Details >> ReportXYZ
Public >> Reports >> Division1 >> Purchasing >> Details >> Report Last Year

```

I always need the information following the last ">>"

So the returned values would look something like:

```
Report_Name
-----------
ReportABC
ReportXYZ
Report Last Year

```