if procedure and function are same in plsql then why we need to go function

Question

I want to know,if procedure and function both return the value in plsql so why we need to go function in plsql.

score 0 · Answer 1 · edited May 23 '17 at 12:08

0

The function and procedure is not the samething . Please refer the below link for reference. What is the difference between function and procedure in PL/SQL?

edited May 23 '17 at 12:08

Community

answered Jun 16 '16 at 14:36

Ashish Awasthi

score 0 · Answer 2 · answered Jun 16 '16 at 18:32

Procedures and Functions are not same there are lot of difference please find below one simple one for better understanding

Function

Select substr('abc',1,2) from dual - is possible

Procedure

Select sample_procedure('abc') from dual - is not possible

2 Answers2