(1) Procedure may or may not return value but function should. (2) We

What is difference between Procedures and Functions ?

Question Posted / roopesh kumar

Answer Posted / roopesh kumar

(1) Procedure may or may not return value but function
should.

(2) We can't call a procedure inside a sql stmt but
function can.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is embedded sql with example?

1099

Write a query to find the names of users that begin with "um" in sql?

1046

Can we perform dml in function?

1137

What is scope of pl sql developer in future?

1076

What is the life of an sql statement?

1076

What is natural join in sql?

1047

What is your daily office routine?

2320

What is database sql?

1101

What is rollback?

1189

What is self-join and what is the requirement of self-join?

1197

What is a trigger in sql?

1236

What is execute immediate?

1166

Does sql backup shrink transaction log?

1045

What is the difference between subquery and correlated query?

1121

Is sql harder than python?

1159