Originally posted by ronnie
I tried executing the above query on 8.1.7 and it gives me an error saying "Invalid column name" for SYS_CONNECT_BY_PATH

Thanks
Ron
SYS_CONNECT_BY_PATH is new to 9i. Hence it won't work in 8i.