Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> connect by ora-01436
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);
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:
Kindly correct me how to write such query
pjp Received on Fri Feb 17 2006 - 04:06:36 CST