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

Maxim:

I was able to use your solution in my application. Can you explain how this works?

Thanks very much, Sidney

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

On Mar 8, 10:12 am, Maxim Demenko <mdeme..._at_arcor.de> wrote:
> > 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:29:21 CST