SQL & PL/SQL

Hi everybody,

I'm new to Oracle SQL resp. PL/SQL and looking for a method to receive manipulated and combined data via SQL.

In MS SQL Server I can define a function that returns a table like this:

CREATE FUNCTION LargeOrderShippers ( @FreightParm money )
RETURNS @OrderShipperTab TABLE
(
ShipperID int,
ShipperName nvarchar(80),
OrderID int,
ShippedDate datetime,
Freight money
)
AS
BEGIN
INSERT @OrderShipperTab
SELECT S.ShipperID, S.CompanyName,
O.OrderID, O.ShippedDate, O.Freight
FROM Shippers AS S INNER JOIN Orders AS O
ON S.ShipperID = O.ShipVia
WHERE O.Freight > @FreightParm
RETURN
END

Is there a similar way to get back a table in Oracle? Since I need calculated values depending on record and filter criteria views won't work for this purpose.

Regards,
Stefan