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

From: Maxim Demenko <>
Date: Sat, 08 Mar 2008 17:12:29 +0100
Message-ID: <>

> 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