Re: SQL Question

Try this:

select label_stuff
from your_table, (select rownum from dba_objects where rownum < 23) order by label_stuff;

This will give you 22 of each row.
You can use any table instead of dba_objects as long as it contains at least 22 rows.

Chris Daugherty wrote:

> Hi.
> I have to print out 22 labels for every row in an Oracle table. Is there
> a way to do this in an SQL statement? Thanks for you help in advance.
>
> Please response by e-mail as well as posting the answer.
>
> Chris Daugherty
> cmdaugherty_at_pier1.com
>
Received on Sat Sep 12 1998 - 00:00:00 CEST