Get Navigation Using Component Name

Select distinct rtrim(reverse(sys_connect_by_path(reverse(portal_label), ' > ')), ' > ') path

from psprsmdefn

where portal_name = 'EMPLOYEE'

and portal_prntobjname = 'PORTAL_ROOT_OBJECT'

start with portal_uri_seg2 LIKE upper('<Component Name>')

connect by prior portal_prntobjname = portal_objname

Note: This query doesn't work with DB2 Database.

Sample Output: