Sweet! That works perfectly (almost all the time). I am currently in 9i, so I do not have the NOCYCLE option for the PRIOR TO clause so any cyclical relations give me the "CONNECT BY loop in user data" error. However, I can deal with that.
>The basic cool page about ORACLE DDL & DML is
Morgan's Library... and
CONNECT BY.
>
>MartiJ
>
>>Thanks, Martin, I should have realized that there wouldn't be an "s" at the end of "START" if there wasn't one on "CONNECT" <g>. Been too long...
>>
>>>L<
Mark McCasland
Midlothian, TX USA