Hierarchical query when used as sub query gives : ORA-00911: invalid character

Hierarchical query when used as sub query gives : ORA-00911: invalid
character

References

Reference NO 1

http://stackoverflow.com/questions/15197912/hierarchical-query-when-used-as-sub-query-gives-ora-00911-invalid-character

Reference NO 2

http://stackoverflow.com/questions/15506531/issue-with-pl-sql-query-of-how-to-use-exists-and-not-exists

Reference NO 3

http://stackoverflow.com/questions/13971718/extractvalue-xmltype-query-delay

Reference NO 4

http://stackoverflow.com/questions/13949660/how-to-optimize-query-with-pl-sql-developer

Reference NO 5

https://forums.oracle.com/thread/938767

Reference NO 6

http://oraganism.wordpress.com/tag/bug/

Reference NO 7

#EANF#

Reference NO 8

#EANF#