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: 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: Thu Dec 08 06:35:28 CST 2016

Total time taken to generate the page: 0.17782 seconds