(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

how to use in conditions? : Sql dba

507

Is sql developer case sensitive?

512

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

527

What is trigger and how to use it in sql?

529

What is join view in sql?

505

Can you rollback after commit?

520

What are the advantages of sql? Explain

642

explain advantages of innodb over myisam. : Sql dba

636

does sql support programming? : Sql dba

603

what is blob? : Sql dba

560

What are the usages of sql?

558

Can a foreign key be a duplicate?

499

explain commit and rollback in mysql : sql dba

539

What is an inconsistent dependency?

575

Why query optimization is needed?

510