Parent Child Relation Query in Oracle

This query brings the records where record is related with parent
records

select parent
from relation
start with child='d2'
connect by prior parent = child;