OraFAQ Forum: SQL & PL/SQL » Diff. of Function and Procedures

Home » SQL & PL/SQL » SQL & PL/SQL » Diff. of Function and Procedures

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Diff. of Function and Procedures [message #36792]

Thu, 20 December 2001 18:54

kothari Alpesh
Messages: 27
Registered: December 2001

Junior Member

I knew the basic diff. of the procedure and function is that the function will give return (single) value and procedure dosent give any value return back but make some process on the input data. but still i want to further clear to my self what is the diff between procedure and Function??

----------------------------------------------------------------------

Report message to a moderator

Re: Diff. of Function and Procedures [message #36795 is a reply to message #36792]

Fri, 21 December 2001 00:40

Phenoracle
Messages: 35
Registered: March 2001

Member

Hi,

You have got the basic diffs.between a function and a proceudre, but there are ways to get a function to return more than one (single) value.

Have fun

Phenom

tips and tricks

----------------------------------------------------------------------

Report message to a moderator

Re: Diff. of Function and Procedures [message #36810 is a reply to message #36792]

Sun, 23 December 2001 02:19

Nirmal TS
Messages: 2
Registered: December 2001

Junior Member

the diff between a function and a procedure i feel is, a function name will return a value in its place where as a procedure does not.

----------------------------------------------------------------------

Report message to a moderator

Re: Diff. of Function and Procedures [message #36831 is a reply to message #36792]

Mon, 24 December 2001 20:43

Parul Nagri
Messages: 1
Registered: December 2001

Junior Member

Please give me at least 4 differences between them .

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Re: PL/SQL tables
Next Topic:	Re: dynamic pl/sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 07 13:45:52 CDT 2026