Given a node in a tree, I would like write a single SQL query to get all ancestors of that node. The limitations are:

1. The database is external and I have only read access to it.
2. The query needs to be compatible with Oracle 8.1.7

Here is the sample script:

Create Table Tree(
node NUMBER(10),
parentnode NUMBER(10),
)

insert into tree values(1,0);

insert into tree values (11, 1);
insert into tree values (12, 1);
insert into tree values (13, 1);

insert into tree values (2, 0);
insert into tree values (21, 2);
insert into tree values (22, 2);
insert into tree values (23, 2);

insert into tree values (211, 21);
insert into tree values (212, 21);
insert into tree values (213, 21);

insert into tree values (2111, 211);
insert into tree values (2112, 211);
insert into tree values (2113, 211);

For example, the SQL should take 2112 and return 211, 21, 2, 0

P.S: I have used the following query to return the children of 211 & 212 - but don't know how to get the ancestors :

select node FROM tree
START WITH node in (211, 212)
CONNECT BY PRIOR node = parentnode;

I'm a newbie & did search around without much success. Hope you can help!