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!

When we use Procedure and When Function

MuzzJun 13 2015 — edited Jun 15 2015

Hi All

I would appreciate of someone correct me if I'm wrong. I'm asking the below question just for my learning purpose.

Question --     When we use Procedure and When Function?

Answer

When  we want to execute a series of DML statements then we use procedure and when we want to return a single value then we use function.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2015
Added on Jun 13 2015
17 comments
2,631 views