Return table set in stored procedure

From: Nils Magnus Englund <nils.magnus.englund_at_orkfin.no>
Date: Wed, 24 Nov 2004 07:02:14 GMT
Message-ID: <WlWod.553$72.180214272@news.telia.no>

Hi!

I'm quite new to Oracle, coming from a background of dabbling a bit with Microsoft SQL Server (although I'm not particularly experienced with SQL Server either).

What is Oracles equivalent of a stored procedure with parameters, returning a result set?

e.g. in MSSQL I could do this:

CREATE PROCEDURE SelectMoreThan (@Value INT) AS BEGIN
SELECT * FROM table WHERE column > @Value END And running "EXEC SelectMoreThan 5" would return to me all rows with a Column value exceeding 5. How would I accomplish the same in Oracle?

Thanks!

Sincerely,
Nils Magnus Englund Received on Wed Nov 24 2004 - 01:02:14 CST