SQL query

Hi,

Can someone help me with the sql query. It is similar to emp_id and manager_id.

create table account_test(id number, parent_id number);

insert into account_test values(1,null);
insert into account_test values(100,1);
insert into account_test values(101,1);
insert into account_test values(102,1);
insert into account_test values(200,100);
insert into account_test values(201,100);
insert into account_test values(300,200);

Here id 1 is parent of 100, 101 and 102
100 is parent of 200 and 201
300 is child of 200

I need to write a query that id 1 can see all records. 100 can see it's and all its child and sub-child i.e. 100, 200, 201 and 300 200 can get 200 and 300.
It will be N-tier parent-child.

Thanks

Sandeep

--
http://www.freelists.org/webpage/oracle-l