Re: SOLVED ORA-01473: cannot have subqueries in CONNECT BY clause

only if somebody will look for ...
"Note that you can't trick Oracle by using CONNECT BY PRIOR on a view that does the join. "

http://www.bf.rmit.edu.au/~orafaq/sql.html#QryTree
http://www.jlcomp.demon.co.uk/faq/connectby.html
http://www-user.tu-chemnitz.de/~igrdb/docs/Oracle/dvs-db-orac-faq.html

JP

On Fri 15. February 2002 19:54, you wrote:
> Hello,
> can somebody help me (or send a web link) to solve problem with ORA-01473?
>
> Thanks
>
> Jan Pruner

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: jan_at_pruner.cz

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).