ORA-01788 – CONNECT BY clause required in this query block

[leandrolbsParticipante]

caso vc possua o campo LEVEL na tabela TESTE use alias…

ex.

select t.level from teste t

caso contrario use desta forma

http://psoug.org/reference/connectby.html