In message <WlWod.553$72.180214272_at_news.telia.no>, Nils Magnus Englund
<nils.magnus.englund_at_orkfin.no> writes
>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?
>
>
>
>
Have a look at Table Functions in the "PL/SQL User Guide and Reference"
--
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Received on Wed Nov 24 2004 - 15:30:09 CST
