Oracle-L: RE: SQL Brain Teaser Challenge

From: Orr, Steve <sorr_at_rightnow.com>
Date: Tue, 05 Nov 2002 11:14:58 -0800
Message-ID: <F001.004FC105.20021105111458@fatcity.com>

Nope...

SQL> l
  1 SELECT *
  2 FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder)   3 START WITH parentid=0
  4* CONNECT BY PRIOR ID = parentid
SQL> /
  FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder)

ERROR at line 2:
ORA-01472: cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.

I supplied the DDL/DML so you could test on your own systems.

-----Original Message-----
Sent: Tuesday, November 05, 2002 12:07 PM To: 'ORACLE-L_at_fatcity.com'; Orr, Steve

SELECT *
FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder) START WITH parentid=0
CONNECT BY PRIOR ID = parentid
Does this work?
Also see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:921234804 9
Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Orr, Steve
INET: sorr_at_rightnow.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Tue Nov 05 2002 - 13:14:58 CST