Can any body tell me is there any support in Oracle
For getting the result in nested way
Something Like
Select con.Name , (Select state.name from state where state.country = con.name ) from Country con

And Returns the result in following Format

USA
[California
Washington]

India
[DeLhi
Maharashta
Haryana ]
ie result in TREE Format

That is single Occurence of USA , India

NOT LIKE
USA California
USA Washington

India DeLhi
India Maharashta
India Haryana

There is support for this thing Using Break But i Want if it is possible to take the resultSet in that way ( ie Java ResultSet)