connect by ora-01436

From: toto <parag9i_at_gmail.com>
Date: 17 Feb 2006 02:06:36 -0800
Message-ID: <1140170795.969667.304470@o13g2000cwo.googlegroups.com>

Hi,

 create table t
 (
  a number,
  b number,
 c number,
  d number);

Table created.

insert into t values (1, 1, 1, 1);
insert into t values (2, 2, 1, 1);
insert into t values (3, 3, 1, 1);
insert into t values (4, 4, 2, 2);
insert into t values (5, 5, 5, 5);
insert into t values (6, 6, 6, 6);
insert into t values (7, 7, 6, 6);

commit;
11:59:28 SQL> select * from t;

         A B C D ---------- ---------- ---------- ----------

         1          1          1          1
         2          2          1          1
         3          3          1          1
         4          4          2          2
         5          5          5          5
         6          6          6          6
         7          7          6          6

7 rows selected.

In this my parent records is always where a=c and b=d.

I want to write "hierarchical query" by following but it is giving me an error

14:20:04 SQL> select *
14:25:51   2  from t
14:25:51   3  start with a=c and b=d
14:25:51   4  connect by prior c = a and prior d = b;

ERROR:
ORA-01436: CONNECT BY loop in user data

Kindly correct me how to write such query

pjp Received on Fri Feb 17 2006 - 04:06:36 CST