Re: cannot have subqueries in CONNECT BY clause

From: Alexander V. Silantiev <silantiev_at_bashkortostan.ru>
Date: Mon, 19 Nov 2001 17:23:40 +0500
Message-ID: <9tath4$t87$1@poikc.bashnet.ru>

>Answer to me, please.
>Are there Oracle server version in that not exists
>restriction ''ORA-01473: cannot have subqueries in CONNECT BY clause' ?
>Thanks in advance.
>

There are (sketchy):

create table classify(
cid type1,
cmaster type1,
CONSTRAINT pk_classify PRIMARY KEY(cid) using index tablespace budget_index, CONSTRAINT fk_classify_master FOREIGN KEY(cmaster) REFERENCES classify ) tablespace budget_data;

create table classifyRW (
cid,
username type2,
CONSTRAINT pk_classifyRW PRIMARY KEY(cid,username) using index tablespace budget_index,
CONSTRAINT fk_classifyRW_classify FOREIGN KEY(cid) REFERENCES classify ON DELETE CASCADE
) tablespace budget_data;

create or replace view classify_rview as select cid,cmaster from classify f
where exists(select null from classifyrw where cid=f.cid and username=user);

And 'ORA-01473: cannot have subqueries in CONNECT BY clause' appears when

select * from classify_rview start with cmaster is null connect by prior cid=master;

is run; Received on Mon Nov 19 2001 - 06:23:40 CST