Home » SQL & PL/SQL » SQL & PL/SQL » Query help
Query help [message #185642] Wed, 02 August 2006 16:53 Go to next message
pflucker
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,

Mario
Re: Query help [message #185651 is a reply to message #185642] Wed, 02 August 2006 21:14 Go to previous message
rleishman
Messages: 3727
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: Mon May 29 12:04:14 CDT 2017

Total time taken to generate the page: 0.08621 seconds