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>
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