Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Differences between Function and Procedure.

SrikardJun 5 2014 — edited Jun 5 2014

Please explain me the difference between a Function and a Procedure.

One of the major differences i read/heard is DML statements cant be written in a Function. But one of my colleagues proved it wrong.

So please some one make me understand deeply. Is this feature new one? or its been there since long? if its been there since long, then why is it written everywhere like that?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2014
Added on Jun 5 2014
13 comments
4,804 views