Table/view to generate integers from 1 to 500

From: Edzard <edzard_at_volcanomail.com>
Date: 16 Jan 2005 04:27:38 -0800
Message-ID: <5d75e934.0501160427.1f3f96b9@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 Received on Sun Jan 16 2005 - 06:27:38 CST