Re: this is probably a stupid question...
Date: Fri, 08 Jan 1999 08:54:50 GMT
Message-ID: <3695c366.68189230_at_firewall.celltech>
On Fri, 08 Jan 1999 03:24:35 GMT, ryanrich_at_<NO SPAM>flash.net (Ryan) wrote:
>What's the difference between a 'function' and a 'procedure' ? The
>only thing I can figure is that a function holds procedures.
It's not just Oracle: virtually all high level languages differentiate procedures and functions.
Basically the difference is that a function returns a value of some sort when it is called whereas a procedure does not. So when you define a procedure, you would say soemthing like:
PROCEDURE MYPROC(parameter1, parameter2) IS
...
...
whereas a function would be defined like:
FUCNTION MYFUNC(parameter1, parameter2) RETURN VARCHAR2 IS
...
...
You may or may not have parameters for either a function or a procedure.
James Petts Received on Fri Jan 08 1999 - 09:54:50 CET