Re: Return multiple copies of same row in table with sequence number

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Sat, 08 Mar 2008 17:12:29 +0100
Message-ID: <47D2BAED.4090808@arcor.de>


> OK, here we need DUAL (at least I do):
>
> Urs Metzger

select level seqno,employeeno, employeename, certificatecount from employees
where department=101
connect by level<=certificatecount
and prior employeeno = employeeno
and prior dbms_random.value is not null

Best regards

Maxim Received on Sat Mar 08 2008 - 10:12:29 CST

Original text of this message