Re: Table/view to generate integers from 1 to 500

"Edzard" <edzard_at_volcanomail.com> a écrit dans le message de news:5d75e934.0501160427.1f3f96b9_at_posting.google.com...
| Is tehere a suitable table in Oracle catalog to select just integer
| values etween 1 and N, where N is at least 500?
|
| Need this as driving table for a report based on a view, where the
| view calls a stored procedure.
|
| E.G function calc_fuel (in_ship, in_date)
| view daily_fuel_consumption (ship, day, fuel)
| select ship,
| trunc (sysdate) - x.i day,
| calc_fuel (ship, trunc (sysdate) - x.i) fuel
| from ship, x
| where x.i between 1 and 31
|
| It is easy enough to create x as an auxilary table but this requires
| DML in the customer database.
|
| Is there a solution with just views or stored procedure?
|
| Edzard Pasma

select rownum
from (select 1 from dual group by cube(1,2,3,4,5,6,7,8,9)) where rownum <= 500
/

Regards
Michel Cadot Received on Sun Jan 16 2005 - 08:57:00 CST