SELECT T.PK_CORP, t.fathercorp as fcorp FROM BD_CORP T START WITH T.Pk_Corp = '1070' CONNECT BY PRIOR T.PK_CORP = T.FATHERCORP