(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 a dirty read sql?

1139

Is sqlite free?

975

Why is partition used in sql?

1123

What are the types of keys?

996

Why truncate is used in sql?

1005

Does mysql support pl sql?

1175

What are the two types of periodical indexes?

940

What is information schema in sql?

1070

How to run sql statements with oracle sql developer?

1070

Why do we use procedures in sql?

1086

Is sqlite thread safe?

1053

What is scalar function in sql?

1040

What are the different types of tables in sql?

1009

What is write ahead logging in sql server?

1052

What is pivot in sql?

915