Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable(
   ID        INTEGER  NOT NULL PRIMARY KEY 
  ,NAME      VARCHAR(18) NOT NULL
  ,PARENT_ID INTEGER  NOT NULL
);

begin
INSERT INTO mytable(ID,NAME,PARENT_ID) VALUES (01,'John',04);
INSERT INTO mytable(ID,NAME,PARENT_ID) VALUES (02,'Paul',01);
INSERT INTO mytable(ID,NAME,PARENT_ID) VALUES (03,'George',02);
INSERT INTO mytable(ID,NAME,PARENT_ID) VALUES (04,'Ringo',03);
end;
/
1 rows affected

	select id, name, parent_id, connect_by_iscycle
	from mytable
	connect by nocycle id = prior parent_id
	start with id = 4


ID
NAME
PARENT_ID
CONNECT_BY_ISCYCLE


4
Ringo
3
0

3
George
2
0

2
Paul
1
0

1
John
4
1