Home » SQL & PL/SQL » SQL & PL/SQL » Query help
Query help [message #185642] Wed, 02 August 2006 16:53 Go to next message
Messages: 2
Registered: May 2006
Junior Member
I have a table (orders) with the columns
order_id varchar2
quantity number

For order_id '001', quantity = 8

Is there a query that will return eight rows with the numbers 1 through 8 for this order? I tried using ROWNUM, but did not get anywhere.

Thanks in advance,

Re: Query help [message #185651 is a reply to message #185642] Wed, 02 August 2006 21:14 Go to previous message
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Search for "row generator"
Previous Topic: Procedure to validate an IP Address
Next Topic: count in SQL*LOADER
Goto Forum:

Current Time: Fri Oct 28 13:21:59 CDT 2016

Total time taken to generate the page: 0.11184 seconds