Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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 - 10:39:43 CDT