(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 are sql commands?

1010

Are sql connections encrypted?

1022

Can we use ddl commands in pl sql?

1160

What is a table in a database?

1044

What is the basic form of sql query?

943

Why do we create views in sql?

1149

How many types of privileges are available in sql?

1346

What is sqlerrd?

968

What does <> sql mean?

1084

How bulk collect improves performance?

1000

What is sql and db2?

998

Is sql a scripting language?

994

what is the difference between primary key and unique key? : Sql dba

1036

Which normal form is best?

948

What are the indexing methods?

1048